Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to protect the cell's formula not be deleted
I have formula in cells, how can I protect this formula from being deleted
when the user select this cell and delete the content. eg. in cell C10, the formula is =A10 * 2 If the A10 has value of 10, then C10 will be 20. If the user select A10 and delete the content 20, then the formula will also be deleted. How do I prevent that ? |
#2
|
|||
|
|||
Select all cells Format cells protection Uncheck Locked Select the cell with formula Format cells protection Check Locked Tools Protection Protect sheet (password is optional) Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=379573 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro or Formula to remove Text from Cells | Excel Worksheet Functions | |||
pasting or moving formula cells without updating formulas | Excel Discussion (Misc queries) | |||
How To Use Cells Without Values in a Formula | Excel Worksheet Functions | |||
My formula screws up other reference cells... | Excel Discussion (Misc queries) | |||
Cells displays formula, not results | Excel Worksheet Functions |