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?

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?

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?