Warning when formula in a cell is changed
 

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?

Warning when formula in a cell is changed
 

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

Jim Thomlinson


"Lciotinga" wrote:

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?

Warning when formula in a cell is changed
 

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
"Lciotinga" wrote in message
...
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?

Warning when formula in a cell is changed
 

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?

Lciotinga wrote:

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?