STOP that macro!

[Tarver]

I've got some macros in a sheet that run automatically when a change happens.

How can I stop that code from executing temporarily while I work in and update my sheet? Such a simple question and I should know the answer, but everything I've tried fails to stop the macro, short of going in and commenting out every single line of each macro.

Thanks!

 

[Fluff]

You can run this

Sub StopEvents()
   Application.EnableEvents = False
End Sub

 

[Taul]

Fluff’s answer is the way to go but I can’t help noticing your comment:-
“short of going in and commenting out every single line of each macro”
Just thought I would point out that you can select a block of code or all of the code and comment it out in one go.
In the VBE, go to VIEW, TOOLBARS and select the EDIT toolbar.
There is an icon to comment out a selected range and the icon to the right of that to uncomment the selection.

HTH
Paul.

 

[Tarver]

Surprisingly, Fluff's method didn't work for me. I can run that macro but things continue to run regardless.

Your solution is less elegant but perfectly effective. Thanks, Taul!

 

[Fluff]

Are the macros either worksheet or workbook event codes?

 

[Eric W]

Another thing you can try is to put the line

Exit Sub

as the first line in the procedure. Then comment that out or not as your testing indicates. This allows some event procedures to run if need be.

 

[Tarver]

Are the macros either worksheet or workbook event codes?

Yes. As soon as a change is made or a drop-down selection is chosen, the macros run.

 

[Fluff]

In that case disabling events should have worked.