PDA

View Full Version : Solved: Sheet Change Event



zoom38
03-22-2007, 06:58 AM
Is there a way to prevent a Sheet Change Event from activating until after a macro completes?

Bob Phillips
03-22-2007, 07:03 AM
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
03-22-2007, 07:04 AM
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
03-22-2007, 07:29 AM
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
03-22-2007, 08:40 AM
No, you will need to force it after you re-enable events.