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
HIS


"?????" wrote in message
...
thank you but i need to know by any number
if the sheet is now protected (not the cell)
rozent

"Nick Hodge" wrote:

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
HIS


"?????" wrote in message
...
is ther any formula that can sow "1" if the activesheet is protected
and "0" if not

rozent