Ignore worksheet change routines while macro is doing updates

AntMac

Board Regular
Joined
Dec 1, 2009
Messages
131
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?
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
10,486
Use

Application.EnableEvents = False

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

AntMac

Board Regular
Joined
Dec 1, 2009
Messages
131
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,813
Messages
5,574,483
Members
412,596
Latest member
nickthebizz
Top