disable selection change vba while running other code

[andrewb90]

Hello all,

I notice that my code is always running through my various selection change codes when I run a macro, is there any way I can have those bypassed while macros are running? I feel that would speed things up.

 

[gallen]

You need to disable events when running then enable.

Caveat: ensure you use error handling and re-enable events if errors occur

Use this code and set to true to re-enable.

Application.EnableEvents = False