| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking formula but delete cell information
I need to be able to delete a number from a cell that ALSO has a formula or
function. I searched but didn't find what I need. This is the drill... 1.) Example: =IF(B10=127,"$16.00","") 2.) Someone ACCIDENTLY enters XX into the cell 3.) UGHH. They hit delete 4.) =IF(B10=127,"$16.00","") goes BYE, BYE!! How do I LOCK the formula, but have access to the SAME cell. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking cell to protect the formula | Excel Discussion (Misc queries) | |||
| locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
| locking formula cell references | Excel Worksheet Functions | |||
| Locking A Formula In A Cell | Excel Worksheet Functions | |||
| locking information | Excel Worksheet Functions | |||
Threaded Mode
