Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Does anyone know a code snippet that will suffice to
check whether or not a worksheet is protected? I've begun using the following code which checks the ProtectScenarios property, however, am not sure if this really is appropriate, since I've not set up any scenarios in the workbook, and am concerned about the possibility of unpredictable behavior. If Worksheets("myWorksheet").ProtectScenarios Then MsgBox "This workship is protected." Else MsgBox "Sheet is not protected" End If Thanks for any suggestions. Lloyd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Check if Worksheet TAB is protected or Not | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
Spell check in a protected sheet | Excel Discussion (Misc queries) | |||
password protected a check box | Excel Worksheet Functions | |||
Check if activesheet is protected | Excel Programming |