| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock formulas only not data
I would like to protect, lock or keep someone from accidently deleting a
formula in Excel 07. I do not want to password protect the workbook or worksheet. We need to enter data into the cells and then select most of the worksheet all at once and hit delete, when the data is deleted I do not want to lose the formulas. Can this be done? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lock only formulas, not worksheet | Excel Discussion (Misc queries) | |||
| Lock formulas in a cell | Excel Discussion (Misc queries) | |||
| How do I lock cell formulas??? | Excel Discussion (Misc queries) | |||
| Can u lock individual cells (those containing formulas) in an Exc. | Excel Discussion (Misc queries) | |||
| how do I lock formulas, but I can still delete data? | Excel Worksheet Functions | |||
Threaded Mode
