Code behind tab not executing

[atf32]

For some reason, all code (i.e., onchange, worksheet_activate, worksheet_deactivate) behind my tabs are not executing automatically. I know that they run, bc, I can step in them to execute them. Also all of my other code runs as expected. Could there actually be a setting that is preventing worksheet code from executing, but not the other code?

 

[Joe4]

Chances are you disabled Events in one of your code blocks, and didn't re-enable it.
In order to avoid changes made by code triggering itself and getting caught in an endless loop, this line of code is often used:

Application.EnableEvents = False

This disables the automatic running of your event code.
However, it need to be turned on again as your code finishes running, or else the "automatic" code won't work anymore.
So any block of code where you have the line above, you will also need this line at some point after it:

Application.EnableEvents = True

However, if you exit the code before getting to this last line (either because you placed it in the wrong place and are exiting before hitting it, or because your code stopped because it hit an error), you will experience what you currently describing.

You can just manually turn it back on by running this short little procedure.

Sub ReEnableEvents()
    Application.EnableEvents = True
End Sub

And make sure that you address any parts of your code that could be causing this to happen.

 

[atf32]

You are absolutely right!!! Was a very long day, so I totally over looked that. Thank you very much.

 

[Joe4]

You are welcome.