Determining when Excel "Protect Sheet" has been activated

[psully52]

I'm interested in knowing not just at a cell level, but at a sheet level whether the "Protect Sheet" has been enabled and would like to display that in a cell. In a prior post (

http://www.tek-tips.com/viewthread.cfm?qid=1185020)

I learned about whether the protection for a particular cell was enabled, but if I want to show whether the protection has been activated for the entire sheet (with a password for example) is there a way to show this in a cell?

What this will allow my users to do is to see at a glance whether the protection is set on any number of sheets in a workbook, so that they can quickly set/ermove it as needed.

Thanks,

Patrick

 

[DaleWatson123321]

One method for a quick determination of whether Sheet Protection has been enabled...

...simply have your users look at the "Formatting" toolbar.

If Protection is enabled, the icons on this Formatting toolbar will be GRAYED out. And this is the case regardless of the cell they are on - i.e. even if the cell is NOT "Locked".

Hope this helps.

Regards, Dale Watson

 

[sawedoff]

Possibly the easiest way would be to add a "Protect Sheet" button to a visible toolbar, and then when the sheet is protected, it will say "Unprotect" instead of "Protect".

Just choose Tools > Customize, and drag the Tools > Customize button out to a commonly used or custom toolbar.

Sawedoff

 

[dcompto]

Maybe the following will have what you need...

http://www.mrexcel.com/board2/viewtopic.php?t=42540&highlight=protect+unprotect+form