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

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
12,325
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,957
Messages
5,856,511
Members
431,819
Latest member
hellosunshine

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