Checking Protect status

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
That is one of four types of Protection that can be applied to a worksheet.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Verify protection status within a macro 1
Unprotect, Run Action then Protect 2
Controlling worksheet protection via VBA 0
Excel Move or Copy Stopped Working? 0
Spell Checking on a protected sheet 1
Protecting worksheet cause vba code to fail 7
Select statement or me? 12
Chartobjects protected but it can still be deleted, edited and movedby the user (yes, the sheet is p 5

Back
Top