Protect formula
 

Hi,

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

Cheers!!

Protect formula
 

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


"macropod" (del NO.SPAM) wrote in message
...
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.

"gav meredith" wrote in message
...
Hi,

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

Cheers!!




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.627 / Virus Database: 402 - Release Date: 16/03/2004

Protect formula
 

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.

"gav meredith" wrote in message
...
Hi,

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

Cheers!!




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.627 / Virus Database: 402 - Release Date: 16/03/2004