I have a user form with a calculated amount column that contains
formulas.
My users inadvertantly keep deleting these cells.
If I lock them and enable protection, they don't let the program change
calculated values.

My idea was:
To move these cells out of site,
Trigger an ON CHANGE EVENT to run a macro which will copy and PASTE
VALUES ONLY back to the form.

Problem is that the ON CHANGE EVENT only triggers on changes in the
cells formula, not in its calculated displayed value.

Any ideas?