preventing code from running
 

hi all
I'm sure this is easy, but I'm a bit stuck.

I have a sub that is executed when the Worksheet_Change event fires. There
is also a macro that I run (mod_Evaluate) while working on that sheet. Both
sets of code work fine, but...

I want Worksheet_Change code to be in effect at all times EXCEPT when I run
mod_Evaluate. What code can I add to mod_Evaluate to temporarily stop the
Worksheet_Change code?

Thank you
anny

preventing code from running
 

Application.EnableEvents = False
'Your macro code
Application.EnableEvents = True
HTH Otto
"anny" wrote in message
...
hi all
I'm sure this is easy, but I'm a bit stuck.

I have a sub that is executed when the Worksheet_Change event fires.
There is also a macro that I run (mod_Evaluate) while working on that
sheet. Both sets of code work fine, but...

I want Worksheet_Change code to be in effect at all times EXCEPT when I
run mod_Evaluate. What code can I add to mod_Evaluate to temporarily stop
the Worksheet_Change code?

Thank you
anny