Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PROTECT FORMULA | Excel Discussion (Misc queries) | |||
Protect individual cell and hide formula in formula bar | Excel Worksheet Functions | |||
Protect a formula | Excel Discussion (Misc queries) | |||
Protect formula | New Users to Excel | |||
How do you protect the formula? | New Users to Excel |