Warning when formula in a cell is changed

[Lciotinga]

I am building a template and I cannot lock all the cells with formulas from
users. I do want to see when a formula in a specific cell has been changed
from the original. Is there a way to do this with other formulas?

 

[Jim Thomlinson]

Nope... Why do you need to allow users to change formulas? That seems like a
really bad idea.

 

[Otto Moehrbach]

Not with other formulas, but you can use a Worksheet_Change event macro to
tell you that the formula has been changed and to take whatever action you
want. HTH Otto

 

[Bob I]

Perhaps place the same formula on a locked sheet and then Conditionally
format the cell in question to be red if the cells values are not the same?