Excel 2003 - how to check is all worksheet is protected

D

DC

Im using Excel 2003.
Is there a built-in function (without using Macro or vba) that allows me to
check is all the sheet in a workbook are protected ?

I have checked File>Properties>Content. Unfortunately it only show the
sheets' names only.....so nice if besides it is stated "protected" or "unprotected"

Regards,

DC
 
G

GS

Im using Excel 2003.
Is there a built-in function (without using Macro or vba) that allows
me to check is all the sheet in a workbook are protected ?

I have checked File>Properties>Content. Unfortunately it only show
the sheets' names only.....so nice if besides it is stated
"protected" or "unprotected"

Regards,

DC
Click to expand...

Activate the sheet and see if the Protection menu Caption is Protect or
Unprotect.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you Determine if a Worksheet is protected? 2
How to bypass password when pasting FROM a protected workbook 3
Protect sheet but allow sorting only 4
Editing an unprotected Cell in a Protected Worksheet in Excel 2003 1
Is it possible to tell at a glance if a sheet is protected? 1
Changing Cell Colour in Protected Sheet 1
Enabling Spell Check in Protected Worksheet 2
Using Autofilter on a Protected Sheet 18

Top