Hiya,

I have a change event macros in a worksheet.
However when I run another macro the event macro gets
triggered, is there any way to turn off the event macro
from this new macro? So anytime I run this macro the event
macro doesn't run, but when the new macro finishes the
even macro turns back on.



Regards

SD

Hi SD

Application.EnableEvents = False
'code
Application.EnableEvents = True

If your code errs before resetting it, events are disabled. So make sure you
have an error handler to deal with this.

HTH. best wishes Harald

"Siemen Deol" skrev i melding
...
Hiya,

I have a change event macros in a worksheet.
However when I run another macro the event macro gets
triggered, is there any way to turn off the event macro
from this new macro? So anytime I run this macro the event
macro doesn't run, but when the new macro finishes the
even macro turns back on.



Regards

SD