Checking Protect status
OOPS! Found my own answer. In case anyone else ever needs it:
Activesheet.ProtectContents is a property and returns as True of False value
"Lulu" wrote:
I am having some trouble with an action happening. I suspect it is being
caused by a worksheet being placed in a protected state at an inappropriate
point, before it has had a chance to complete other tasks. "Protect" is a
method, not a property, so how can I check the "protectedness" of the active
sheet. I am trying to come up with a code which reports the protected status
of the activesheet during the sequence of actions.
Ideas?
|