View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default Can't break out of code help!

If you are in debug with the highlight showing, click the Design Mode icon,
if the debug highlight goes out, you are out of the macro. I am betting
that you are using an event code for a sheet_change. If so, before clicking
the icon, put a comment (apostorphe) in front of your macro title. That
will prevent it from running until you can straighten out the code.




"msnyc07" wrote in message
...
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...