Excel 2003 - how to check is all worksheet is protected

  • Thread starter Thread starter DC
  • Start date Start date
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
 
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
 
Back
Top