Protect formula

G

gav meredith

Hi,

Is there a way to protect a formula from being deleted in a cell if a person
deletes the contents (value)??

Cheers!!
 
G

gav meredith

thank you. i was hoping there was a way to do it but oh well....back to the
drawing board!!
 
M

macropod

Hi Gav,

To do this, set the cell's protection to 'locked' and activate the
worksheet's protection.

Cheers
Note that it is not possible to delete a formula's result without deleting
the formula.
 
Top