Cell protection ?

  • Thread starter Thread starter me
  • Start date Start date
M

me

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
 
Tool>Protection>Protect 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 :
Format>Cells>Protection 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.
 
Back
Top