Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't break out of code help!
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't break out of code help!
did you try control break?
-- Gary Keramidas Excel 2003 "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... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't break out of code help!
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... |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't break out of code help!
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... |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't break out of code help!
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... |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't break out of code help!
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" wrote in message ... 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... |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How best to break up code | Excel Programming | |||
OnTime code error "can't execute code in break mode" | Excel Programming | |||
inserting break in code | Excel Programming | |||
Break out of Code | Excel Programming | |||
code break | Excel Programming |