| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula locking
HI,
How would i go about locking formulas in a workbook so that they cant be edited? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
| Locking portions of a formula | Excel Worksheet Functions | |||
| Locking A Formula In A Cell | Excel Worksheet Functions | |||
| locking a formula to cells | Excel Discussion (Misc queries) | |||
| Locking formula for a Sort | Excel Discussion (Misc queries) | |||
Linear Mode
