HELP!!! "Code execution has been interrupted"

Yup. This new computer has been fine with new and old code, and then suddenly I write code in Word and it flares up again. It's like excema. The break line is chosen at random, and it not the sort of line that could cause a problem.

Just thought I'd give an example:

The line I got an error on was " ".

It's a loop, and that's the thousandth time in that iteration that it will have executed the code in the Else section, and suddenly it decides to stop there.

Code execution has been interrupted

I began to experience this issue after using a wireless keyboard plugged into my laptop USB port. I am fairly certain a hardware compatability issue is sending a false break command because of this. - Something to think about.

My solution

I finally found pattern to this, and I think it has solved it in my instance because I can switch the problem on and off! It is associated with Adobe Acrobat 5.0 and specifically the files pdfmaker.xla. This appears to be the problem, though I don't know why?

I removed pdfmaker.xla (and pdfmaker.ppa and pdfmaker.dot) and the problem disappeared. When I restored them, the problem came back. When I removed them again, the problem disappeared again. Coincidence? I don't think so!

I've now completely uninstalled Acrobat and purchased Neevia DocuPrint, which for what I need is a much better piece of software, and only cost $29 US for 2 licenses.

code execution has been interrupted

I have a macro that updates a pivot table everytime a cell is updated.
Trouble is, often I get "code execution has been interrupted" right at the beginning (header line) of the macro.

Does anyone know why this happens?

Txs & cheers

I had this same problem, which took me nearly 2 days to fix - since there is no help for this on the Internet. For me, my program automatically opened and closed when used. So I pressed ctrl-break to edit changes in Visual Basic, and this creates some sort of fatal error in the memory of Excel. What I did is change the program so ctrl-break did not have to be applied to edit the coding. Then I reset the computer to erase the memory in Excel - and it works.

Hope this helps.

Post the Workbook_Open code.

Click to expand...

I have the same issue, but I don't have any code in the Workbook_Open function.

Also when I try to get into atpvbaen.xla or funcres.xls in the VBE I get a password box.

Any help would be appreciated.

just to add to the confusion


I have a worksheet that has been working fine for years -

three new PCs were delivered to the office. Of the 3 two of them work perfectly. The third gives the same error that everybody else is getting

"Code execution has been interrupted"


from my networked location it runs fine, from the other 2 pcs at that location it works fine


it happens as you open the file

using continue gets you through the problem

I even used a remote control to disable their keyboard and mouse and ran it through the controler pc

same result

so diffinately no one is hitting any kind of key - nor is it a keyboard problem

I believe I have a solution for all on this one. Let me explain fully:

How to duplicate and cause the "Code execution has been interrupted" error:

1) Use Ctrl-Break to interrupt a macro--this corrupts things from now on
2) Now, if you add or change any macro code or use break points...
3) Upon rerunning the macro, you may get the "Code execution has been interrupted message".
4) Choosing "Debug" leads you to seemingly random locations--where there is no real error. Continuing execution each time will eventually allow the macro to finish, despite the annoying Code interruption error.

How to fix this error:

Simplest: Fully Reboot/Restart the computer (a logout/login will NOT work!)

Alternative: I've not foolproof it yet, but you can use Application.EnableCancelKey = wdCancelDisabled or = wdCancelInterrupt (Word macro) or = xlDisabled, = xlErrorHandler, or = xlInterrupt (Excel) to change the effect of the Ctrl-Break key.

Note: After using Ctrl-Break, and making macro edits, you may save your macros without worry of corruption. After the reboot, you will find that your saved code will not fail due to the "Code execution has been interrupted" error. Avoid using Ctrl-Break, if possible, and you will have no further problems. :wink:

Solution:

You probably do not declare variables,
you probably recently used Option Explicit

Solution:

You probably do not declare variables,
you probably recently used Option Explicit

Click to expand...

Nope, wrong error message. E.g.,

Error messages are important, read them closely. :wink:

There might be some junk and bloat in your file from manipulating it so much...

Try running the Excel file in question through a different platform, like Excel for the Mac (on a Mac) or Open Office, to rebuild the file's ExCodes. I.e., open and save the file on a different platform. Now retry the file, in Excel.