Run Macro on Cell Change
 

Can someone suggest, pls.............

Cell A1 contains specific data that I don't want changed by user...........
if thiis cell is changed, I want a macro to run to remove the user input and
replace the original data.

i.e., A1 = "Snow is a 4 letter word, shame on you"

Your help is appreciated,

Don

Run Macro on Cell Change
 

Don,
Can you not use worksheet protection ?

NickHK

"Don" wrote in message
...
Can someone suggest, pls.............

Cell A1 contains specific data that I don't want changed by
user...........
if thiis cell is changed, I want a macro to run to remove the user input
and
replace the original data.

i.e., A1 = "Snow is a 4 letter word, shame on you"

Your help is appreciated,

Don

Run Macro on Cell Change
 

Sorry folks.......................I just found the answer on Chip Pearson's
website......http://www.cpearson.com/excel/events.htm
Thanks Chip !!!! :)

Don

"Don" wrote in message
...
Can someone suggest, pls.............

Cell A1 contains specific data that I don't want changed by
user...........
if thiis cell is changed, I want a macro to run to remove the user input
and replace the original data.

i.e., A1 = "Snow is a 4 letter word, shame on you"

Your help is appreciated,

Don