Disable Macro

M

Mark

Is there a way to temporarily disable a macro while
running another macro? I have a macro that is activated
on Worksheet change. I'd like to disable this while the
other macro is running.

Thank you for your help.

Mark.
 
T

Tom Ogilvy

Application.enableEvents = False
'
Application.EnableEvents = True

will stop events for Excel objects from running.
 
Top