Formula locking

D

DaveAsh

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

Thanks.
 
M

Mike H

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
 
Top