Disable Macro

  • Thread starter Thread starter Mark
  • Start date Start date
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.
 
Mark,

You may want to investigate Application.EnableEvents = False

Rob
 
Application.enableEvents = False
'
Application.EnableEvents = True

will stop events for Excel objects from running.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Disable user interaction in VBA 1
How to call Excel add-in macro from a button… 1
Excel TWO Instances of Excel One watching Other 3
open file with macros disable 1
To disable pressing of Enter key on a sheet 1
Combine 2 columns in a dynamic range into one 7
How to call module function or sub from the Add In? 3

Back
Top