On a pretty regular basis, the VBA Editor breaks somehow, so that I can’t step into code (either by pressing F8 or clicking on either the ‘Step Into’ button or the ‘Run to Cursor’ button in the “Debug” menu) and execution of code doesn’t pause on the breakpoints I’ve set or on errors that occur (this despite having selected the “Break on Unhandled Errors” option under the “Error Trapping” group on the “General” tab of VBA’s “Options” dialog box).

To be clear, the ‘Step Into’ and ‘Run to Cursor’ do work in that they run the whole procedure without stopping the code on either the next executable line in the case of ‘Step Into’ or stopping the code at the line where the cursor is currently placed in the case of ‘Run to Cursor.’

I know that code is running because “Debug.Print” statements are working and printing messages to the Immediate window.

The only way I’m able to debug again is by completely closing Excel and reopening it.

I’ve tried closing and reopening the VBA editor, clicking the ‘Reset’ button but neither of these solutions worked. Other than doing the one thing that does work, which is completely shutting Excel down and reopening it, I haven’t the faintest idea how to fix this problem.