easy check for sheet protection
Posted by Hansoh on November 20, 2001 7:19 AM
i would like a quick formula that will give me the state of a sheet's protection (i.e., protected/unprotected). the problem is that i'm forgetting to protect sheets as i close out of files and i need a small reminder...something like '=if(cellprotected, "protected","unprotected"). is there anything like that? please help. thanks in advance.
i think a macro could do this easily, but i don't want to resort to that. if a macro is the only way to do this, please tell me. thanks.
Posted by Juan Pablo on November 20, 2001 8:18 AM
Go to Insert, Names, Define. In the name box put
Protected
and in the refers to, put:
=GET.DOCUMENT(7)
Now, in any cell, of any sheet you want to check put this formula
=PROTECTED
It will return TRUE or FALSE if protected or not. Bad news is it won't recalculate when you protect/unprotect, only when you recalculate any formula.
Juan Pablo
Posted by Hansoh on November 20, 2001 8:31 AM
thanks again, pablo. i will try. (No Text)
Posted by Juan Pablo on November 20, 2001 8:36 AM
Not to be pitty or anything, but i prefer Juan Pablo, or Juan for the shorter version.... :) (NT)
Posted by Juan Pablo on November 20, 2001 8:37 AM
Pitty (???)... meant pecky
Posted by giacomo on November 20, 2001 8:38 AM
a different idea
Not sure if you've considered this but it would be pretty simple to add the "Protect Sheet" command to your toolbar. Just right-click on a toolbar and select "Customize" the select the "Commands" tab go to "Tools" then find "Protect Sheet" and then drag and drop it onto your toolbar.
Posted by Mark O'Brien on November 20, 2001 1:14 PM
Re: Pitty (???)... meant pecky....Or petty :)
Posted by Hansoh on November 21, 2001 9:14 AM
i meant 'juan pablo'; i'm not sure why i wrote 'pablo'...sorry. (NT)
