Ignore worksheet change routines while macro is doing updates

AntMac

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

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
12,425
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
134
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.
 

Forum statistics

Threads
1,172,032
Messages
5,878,823
Members
433,373
Latest member
strichpunkt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top