protect formula

[Guest]

is ther any formula that can sow "1" if the activesheet is protected
and "0" if not

rozent

 

[Nick Hodge]

Rozent

=Cell("Protect")

will return 1 if the cell is locked and 0 if the cell is unlocked and the
worksheet protected

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Guest]

thank you but i need to know by any number
if the sheet is now protected (not the cell)
rozent

 

[Nick Hodge]

A cell cannot be 'locked' without the sheet being protected, so this should
show you if the sheet is protected???

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Guest]

i am sorry but no. read carefully:
the sheet is usualy protected but the user can unprotect when he wants
i want that when he unprotect, sume celles will automaticaly changh colors
until he protect again.
a locked cell is not change its formula results when the protection is
removed.
the result is 1 or 0 depending of the locking deffinition but not changing
every
time when he protect or unprotect the sheet. if the result will be changhed
automaticaly also the colors will be changed (by conditional formatting)
rozent