Stuck in endless loop, HELP!

D

David

I stupidly ran some code that is in an endless loop and displays a
message box and now can't get out of it, the message box wont go away
so I can save the code or anything, any ideas?

Is there a way of stopping macros running once started? The stop
button isn't working.

Thanks, I don't really want to re-write it all again.
 
P

papou

Hello David
If you want to brutally stop the macro running, you can try Ctrl + Pause.

HTH

Cordially
Pascal
 
C

Charlie

Speaking of saving your life...you may also want to try saving your workbook
after making significant changes and before running any macros. I have a
number of times wiped out sheets inadvertantly. I was glad I was able to
quit without saving changes because I had already hit the sloppy-disk icon
before running the macros.

I also like to make copies of the workbook throughout the day in case I need
to go back to one.

Charlie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Event Endless loop :-( 3
Do Until - If-then problem 5
Do Until ... loop - endlessly 1
Problems with DL Causing Endless Loops 0
endless loop help 1
Message box and loop 4
Do Until or For Loop 3
Can no longer save a file as .docx 7

Top