Checking Protect status
 

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?

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?

Checking Protect status
 

That is one of four types of Protection that can be applied to a worksheet.

--
Regards,
Tom Ogilvy

"Lulu" wrote in message
...
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?