View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default 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