Avoid Delete Formulas

  • Thread starter Thread starter pgjoshi
  • Start date Start date
P

pgjoshi

I don't want to protect worksheet. But when a formula in the sheet i
any cell will be deleted or changed then can I undo the action by usin
sheetchange even
 
Hi
though this is in general possible this would require (depending on the
number of formulas you use and how different they are) a lot of coding
(and hardcoding the formulas into the code or storing themn in static
arrays)

I rellay would suggest using the worksheet protection or is there a
business reason why you can't use protection?
 
Back
Top