code execution has been interupted - Excel 2003
David,
Depending on how your code is written/structured, pressing Escape
or Ctrl + Break will only interrupt your code not stop it.
There is a "reset" button on the Standard and Debug menu bars in the
VBE which will do just that. (looks like a dark square)
Also, take a look in help for the "EnableCancelKey" property.
Make sure to read all of the remarks.
Finally, be aware that overall error handling settings are found in...
Tools | Options | General (tab) in the VBE.
--
Jim Cone
Portland, Oregon USA
"David_W"
wrote in message
After using ctr alt Break to stop a macro mid flow it continues to pop up and
break code running.
Even after I have closed the workbook and try to run the
code in normall fashion this error message constantly re appears.
Only after pressing continue ~ 50 do we return to normall.
Can only assume this is a known bug with the application - but any thoughts
on resolutions / fixes.
Regards, David
|