Can't break out of code help!
in [Programming]
|
Prev: $29.00 FAKE ID FAKE IDENTIFICATION CARDS, FAKE ID'S & NOVELTY ID CARDS
Next: How to open a specific worksheet via code from workbook_open
From: JLatham on 11 Apr 2010 21:30 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...
From: JLGWhiz on 11 Apr 2010 22:59 Maybe you could share with us the type of macro you are running. i.e. Sheet event, control event, etc. Whatever event, if you can get it to debug, you can stop it without losing anything by commenting it out. If all else fails Ctrl + Alt +Del will definitely stop it, but you will lose data. "msnyc07" <msnyc07(a)discussions.microsoft.com> wrote in message news:C996FE4E-3B79-4672-A670-B5FB29F219C3(a)microsoft.com... > In the icon tray in the top? No disc button there... > > "Barb Reinhardt" wrote: > >> When you debug, can you press the little Disc button in the VBE? >> -- >> HTH, >> >> Barb Reinhardt >> >> >> >> "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...
From: msnyc07 on 12 Apr 2010 03:43
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... |