Excel VBA App stops spontaneously with message Code execution has been halted

Question

We have several Excel VBA applications that run flawlessly on a variety of users' computers. On one machine, though, they halt at specific lines of code. It always has the same lines, but they don't seem to be connected in any way.

After the halt, the software resumes if you press F5 (run), thus it's almost like a breakpoint has been added. We've attempted to add breaks and then remove them again, as well as choosing "remove all breaks" from the menu. Previously, when this problem affected a single app, we 'bodged' it by removing code from modules, compiling it, and then pasting it back in, etc.

We're not entirely sure how to handle this since the issue now appears to be with Excel as a whole rather than a specific.xls file.

Answer 1

We have a number of Excel VBA apps which work perfectly. You could write VBA code based on the Change event in the worksheet.  You could write VBA code based on the Change event in the worksheet.

Answer 2

1. Press the "Debug" button in the popup.
2. Press Ctrl+Pause|Break twice.
3. Hit the play button to continue.
4. Save the file after completion.