Warning when formula in a cell is changed

  • Thread starter Thread starter Lciotinga
  • Start date Start date
L

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?
 
Nope... Why do you need to allow users to change formulas? That seems like a
really bad idea.
 
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
 
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?
 
Back
Top