| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PROTECT FORMULA
I want to protect the formulas in the worsheet so that they can not be
deleted or changed. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
PROTECT FORMULA
See help on sheet protection and protecting individual cells.
Basics are you lock the cells you don't want edited then protect the worksheet with a password. Just be aware that Excel internal security is very weak and passwords easily cracked. But to protect cells from inadvertant change it is sufficient. Gord Dibben MS Excel MVP On Fri, 12 Jun 2009 15:17:01 -0700, Donna wrote: I want to protect the formulas in the worsheet so that they can not be deleted or changed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect individual cell and hide formula in formula bar | Excel Worksheet Functions | |||
| Protect a Formula | Excel Discussion (Misc queries) | |||
| Protect a formula | Excel Discussion (Misc queries) | |||
| Protect formula | New Users to Excel | |||
| How do you protect the formula? | New Users to Excel | |||
Linear Mode
