"Code Execution Has Been Interrupted": Excel in focus
http://vbforums.com/showthread.php?t=482840
http://vbforums.com/showthread.php?t=451482
http://www.google.com/search?q=%22code+execution+has+been+interrupted%22
the problems seems to be with some sort of cache filling up. Clearing modules by deleting all code, saving, and then reinserting code seems to help some people. Another website makes mention of mscomdlg.twd but I could not find this file on my system, nor have I been able to rid of the dialog by restarting the computer, clearing all caches and registry entries.
Here another thing, I am running a VBA Script with a simple macro
Sub Mac_0()
Application.Run "Solver.xla!Auto_Open"
SolverOk SetCell:="$e$11", MaxMinVal:=2, ByChange:="$c$3"
SolverSolve UserFinish:=True
End Sub
this is called by a VB6 program. When my application is in focus and excel is in background, everything is fine, but as soon as Excel gains focus and the VBA macro is called from VB6, this prompt pops up, asking me if I want to debug or continue, and I have to keep hitting "C" hoping to get rid of the dialog for long enough to re-focus on a different window. Leaving the dialog up of course will prevent any operations with Excel. I'm dealing with it just by hiding excel, but I'd like to see what is going on in my spreadsheets.
So far there doesen't seem to be a solution, I wonder if anybody here has any ideas?

