Default formula

[bhandari]

is it possible to delete value without formula?

i mean if cells contain formulas..i want them to stay as default..if anyone delete the cell.
formula must stay as default is it possible with macro or any tips?

 

[Eric W]

Try protecting the sheet. First select the cells that you want people to be able to change, right click on them > Format Cells > Protection > and uncheck the Lock box. Now go to the Review tab and click Protect Sheet, with an optional password if you want. Now they can change some cells, but nothing with the Lock box checked. Any formula in it will continue to calculate as normal.

 

[bhandari]

Try protecting the sheet. First select the cells that you want people to be able to change, right click on them > Format Cells > Protection > and uncheck the Lock box. Now go to the Review tab and click Protect Sheet, with an optional password if you want. Now they can change some cells, but nothing with the Lock box checked. Any formula in it will continue to calculate as normal.

Thank you