Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Syntax to check protected status of a worksheet?
I've used ActiveWorkbook.ProtectStructure to return a True/False value
indicating that a workbook is password protected. Does similar syntax exist for the active sheet? I have tried a number of variations but can't find it, and for some reason (reason conversion to XL 2003?) I don't get those popup windows that suggest my next choice of code words. Any ideas? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
spell check protected document | Excel Discussion (Misc queries) | |||
Is it possible to sort a protected worksheet? | Excel Discussion (Misc queries) | |||
Unprotecting Cells in a Protected Worksheet | Excel Discussion (Misc queries) | |||
Sorting protected worksheet | Excel Discussion (Misc queries) | |||
How can I activate cell shading in a protected worksheet? | Excel Discussion (Misc queries) |