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

rozent

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

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

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

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

"Nick Hodge" wrote:

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