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

Question

Hi,

From what I can see on the web, this is a fairly common complaint, but answers seem to be rarer. The problem is this:

We have a number of Excel VBA apps which work perfectly on a number of users' machines. However on one machine they stop on certain lines of code. It is always the same lines, but those lines seem to have nothing in common with one another.

If you press F5 (run) after the halt, the app continues, so it's almost like a break point has been added. We've tried selecting 'remove all breaks' from the menu and even adding a break and removing it again.

We've had this issue with single apps before and we've 'bodged' it by cutting code out of modules, compiling and then pasting it back in etc.

The problem now seems to relate to Excel itself rather than a single .xls, so we're a little unsure how to manage this.

Any help would be gratefully received :)

Thanks,

Philip Whittington

Answer 1

The problem now seems to relate to Excel itself

Reinstall and patch it up :) Other then that its hard to tell.

Answer 2

I would try the usual remedial things: - Run Rob Bovey's VBA Code Cleaner on your VBA Code - remove all addins on the users PC, particularly COM and .NET addins - Delete all the users .EXD files (MSoft Update incompatibilities) - Run Excel Detect & Repair on the users system - check the size of the user's .xlb file (should be 20-30K) - Reboot then delete all the users Temp files

Answer 3

Thanks to everyone for their input. This problem got solved by choosing REPAIR in Control Panel. I guess this explicitly re-registers some of Office's native COM components and does stuff that REINSTALL doesn't. I expect the latter just goes through a checklist and sometimes accepts what's there if it's already installed, maybe. I then had a separate issue with registering my own .NET dll for COM interop on the user's machine (despite this also working on other machines) though I think this was my error rather than Microsoft. Thanks again, I really appreciate it.

Answer 4

I've had this problems dozens of times, and like you, I've gone searching on the web only to find a lack of good answers in how to solve the problem. I believe the exact message I get is "Code execution has been interrupted."

I only get this error when I manually break the code execution in Excel (usually by hitting Ctrl+Break). Once that happens, I usually have to restart my computer to get it to act normal again.

Answer 5

Hi guys, a few of us are starting to get this problem in our office (the 'code interuption popup' appearing while any macro runs).

By the way, we're using some proprietary software (to model the products of an insurer - be nice!). The software is not related to Excel, but to fiddle with its results .txt files, we install an Excel add-in that adds more menus to Excel. But I got the error message myself without really using that software at all. And it really looks like it has nothing to do with the application in question.

Phil can you expand on how to do the 'repair' option you mentioned - did it indeed work? I'm a total layman here, so be patient.