Excel protect documents

J

JT

Is there anyway of protecting multiple sheets in Excel (2007) we are new at
using Excel .

thanks for any assistance

JT
 
B

Beth Melton

JT said:
Is there anyway of protecting multiple sheets in Excel (2007) we are new
at using Excel .

thanks for any assistance
Click to expand...

Are you asking if there's a way to group multiple worksheets and protect
them all at the same time instead of one at a time? You can using VBA by
looping through the worksheets collection and protecting each sheet.
Otherwise you need to select each sheet and protect it.

Or are you asking can you protect worksheets? The Protect Sheet command is
found on the Review tab in the Changes group.

--
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx
 
J

JT

Yes, wanting to protect the sheets all at one time. It looks like VBA is
way out of our league, I was hoping there was an easier method that didn't
require a lot of knowledge - just select and click. I would have thought
that it would have been feature of Excel etc.
 
Top