I have a calculation sheet, where i want to make sure that users dont
accidentally delete the formulas necessary to complete the calculations.
- i've tried protecting the cells, by unlocking certain input cells and
locking the rest, but that for some reason won't allow my 'hide rows, and
insert formulas depending on what is selected from a validated list' macro to
run properly.

my idea now is to have a startup macro, where if the sheet is copied or
whatever, the formulas will be saved in code and inserted into the correct
cells if needed
- or if the formula is accidentally deleted it will re-appear.
where would i insert that coding?

thanks for helping!

Also, if you have a better idea, or a way to fix the 1st problem, let me know!