Cell protection ?

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
 
F

FC

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top