Formula locking
 

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

Thanks.

Formula locking
 

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

"DaveAsh" wrote:

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

Thanks.