Change event

  • Thread starter Thread starter Siemen Deol
  • Start date Start date
S

Siemen Deol

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

Combine 2 columns in a dynamic range into one 7
How to force macros refer to ActiveWorkbook 2
Call a cmdSend_Click macro; non-click interaction 5
Disable Change-event macro 6
Addin not allowing thisworkbook.save in before save event 3
Trapping value before and after change 3
Simple Variable to someone 5
OnTime Change_Event macro AND copy to sheet2 macro trouble 7

Back
Top