Formula locking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI,
How would i go about locking formulas in a workbook so that they cant be
edited?

Thanks.
 
Hi,

Select all the cells you want to be able to edit and click
Format|Cells|Protection
Remove the locked checkmark.

Then

Protect the worksheet using Tools|Protection|Protect sheet.
Note that this is excellent to protect against accidental editing but is not
a secure method to protect against tampering.

Mike
 
Back
Top