Solved: Sheet Change Event

[zoom38]

Is there a way to prevent a Sheet Change Event from activating until after a macro completes?

[Bob Phillips]

You can stop it running by turning off events

Application.EnableEvents = False

and set to True after, but this will not force it to tun after your macro.

[lucas]

I'm not sure what you mean....are you running a macro that causes the sheet change event to fire? If so you might try

Application.EnableEvents = False

at the beginning of your macro....don't forget to set it back to true after the macro runs.

[zoom38]

Yes Lucas my macro makes a change on the worksheet so it activates.
XLD I followed your instructions and it worked except as you said it will not allow the sheet change event to run after the macro.

Thanks
Gary

[Bob Phillips]

No, you will need to force it after you re-enable events.