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: msnyc07 on 11 Apr 2010 20:16 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 20:47 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" <msnyc07(a)discussions.microsoft.com> wrote in message news:39BB57E6-E6F6-456E-87F0-4A1C9B335EE8(a)microsoft.com... > 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: Gary Keramidas on 11 Apr 2010 20:49 did you try control break? -- Gary Keramidas Excel 2003 "msnyc07" <msnyc07(a)discussions.microsoft.com> wrote in message news:39BB57E6-E6F6-456E-87F0-4A1C9B335EE8(a)microsoft.com... > 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: Barb Reinhardt on 11 Apr 2010 20:50 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 11 Apr 2010 20:54
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... |