Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet protection
Hi Sheldon,
You could use a function like: Function IsProtected(Optional ws As Worksheet) As Boolean If ws Is Nothing Then Set ws = Activesheet If ws.ProtectScenarios Or _ ws.ProtectDrawingObjects Or _ ws.ProtectContents Then IsProtected = True End If End Function --- Regards, Norman "Sheldon" wrote in message ... How do I question in code whether a worksheet is protected or not? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet protection | Excel Discussion (Misc queries) | |||
Worksheet protection | Excel Worksheet Functions | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Worksheet tab protection | Excel Discussion (Misc queries) |