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

Dealing with the error: unable to filter on excel hc home school 0
Worksheet protected by Activesync 0
How do you Determine if a Worksheet is protected? 2
How to bypass password when pasting FROM a protected workbook 3
Adding Picture to Protected Worksheet 0
Move direction problem when protected 0
Unprotecting what Excel says is unprotected ??? 2
To protect all worksheet simultaneously in a excel workbook 1

Top