Disable Macro

[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.

 

[Rob van Gelder]

Mark,

You may want to investigate Application.EnableEvents = False

Rob

 

[Tom Ogilvy]

Application.enableEvents = False
'
Application.EnableEvents = True

will stop events for Excel objects from running.