Selective Cell Protection

[zarn]

How can I protect the formula cells so that my customers won't delete them accidentally? Thanks.

 

[Yogi Anand]

Hi Zarn:

Welcome to the Board!

If you mark the cells that have Formulas as Locked and Hidden, and protect the worksheet, the formulas will not be seen, and having locked the cells will not permit tampering with the formulas -- but the worksheet must be protected for these features to kick in.

Regards!

Yogi

 

[Chris Davison]

if they're peppered all over the place ( like mine usually are) a handy way of selecting them all in one go is to highlight your range, then :

edit
goto
special

and click on constants then untick everything except formulas

click ok

this'll select all formulae for you and you can right click in any one of them in order to proceed with Yogi's suggestion above (format, protection, protect and hide)

_________________
Hope this helps,
Chris

[Excel '97; Windows ME]
This message was edited by Chris Davison on 2002-09-22 04:34