View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
msnyc07 msnyc07 is offline
external usenet poster
 
Posts: 93
Default Can't break out of code help!

Thanks all. Excel finally crashed, which it seems to like to do several
times a week, functions or not. Pretty much tired of it as it is next to
impossible to recreate my work.

"JLatham" wrote:

Some things to try:
Go ahead and get into it with [Debug] and then go back to the main window
and click the disk icon to save the file, or attempt plain old File -- Save.

Or maybe once you get into the debug mode, you can add an Exit Sub line of
code just below the line you interrupted it in?


"msnyc07" wrote:

Somehow one of my VBAs got called and I can't get out if it. Esc only calls
up the Dialog box that allows me to End/Continue/Debug, End does nothing,
Debug stops but I still can't CANCEL it. Any suggestions? I am stuck
otherwise and will lose a lot of work...