View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Lulu Lulu is offline
external usenet poster
 
Posts: 18
Default 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?