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...

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" <(E-Mail Removed)> wrote in message
news:39BB57E6-E6F6-456E-87F0-(E-Mail Removed)...
> 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...

did you try control break?

--


Gary Keramidas
Excel 2003


"msnyc07" <(E-Mail Removed)> wrote in message
news:39BB57E6-E6F6-456E-87F0-(E-Mail Removed)...
> 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...

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...

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...

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...

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" <(E-Mail Removed)> wrote in message
news:C996FE4E-3B79-4672-A670-(E-Mail Removed)...
> 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...

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...