Excel Cell Protection - Notification that it is on or off 1

[psully52]

I'm working in Excel, and I'm interested in having a cell indicate whether cell protection is on or off. If on, then the cell would indiicate "Protection On" or something like that, and "Protection Off" if it is off.

Anyone have a suggestion for how to do that?
Many thanks,

Patrick

 

[AnotherHiggins]

=CELL("protect",A1)

will display a 1 if A1 is locked, and a 0 if it is not.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[psully52]

Great - thanks! That is a perfect solution.

 

[dcompto]

The Excel Add-In, ASAP Utilities, has a "conditional select" feature which will, among other things, select all protected cells or all unprotected cells. See

http://www.asap-utilities.com/p_po_cse.php