Cell protection ?
 

Hi,
When a formula is entered into a cell is there a way to protect that
cell so the formula cannot be removed?
Appreciate your assistance

Cell protection ?
 

ToolProtectionProtect Sheet
Password optional then use the check boxes as pleased and click OK
NOTE : ALL cells are protected by defalt when you protect the worksheet.
You can either select which cellss to unlock or which to lock by :
FormatCellsProtection and checking or unchecking the LOCKED BOX.
This last step shoulb be done first.
Also this protection is weak, but can be used for regular users of XL.
" wrote:

Hi,
When a formula is entered into a cell is there a way to protect that
cell so the formula cannot be removed?
Appreciate your assistance

Cell protection ?
 

Many thanks for your reply.
I will try that.
Cheers - appreciated.

On Sun, 17 Aug 2008 11:24:01 -0700, FC
wrote:

ToolProtectionProtect Sheet
Password optional then use the check boxes as pleased and click OK
NOTE : ALL cells are protected by defalt when you protect the worksheet.
You can either select which cellss to unlock or which to lock by :
FormatCellsProtection and checking or unchecking the LOCKED BOX.
This last step shoulb be done first.
Also this protection is weak, but can be used for regular users of XL.
" wrote:

Hi,
When a formula is entered into a cell is there a way to protect that
cell so the formula cannot be removed?
Appreciate your assistance