Ignore worksheet change routines while macro is doing updates

[AntMac]

The situation is the file has a worksheet change subroutine for when the user is entering data. But when a macro is being run, I want to code the macro and not have to worry about the worksheet change sub running because the conclusion of it messes up the macro executing. Even from things as simple as the cell it leaves selected. So, is there a way I have have a macro override those triggers and return to normal once the macro is done?

 

[Eric W]

Use

Application.EnableEvents = False

to stop the change routine from triggering, and set it back to True at the end of your macro.

 

[AntMac]

I always get that mixed in my mind with the screenupdating for some reason. I normally turn off screenupdating instinctively so my brain associates that everytime lol Thank you. Sorry about that.