Am stuck! how do I force exit a macro?

[menos]

I'm such a muppet! I am running a for-next loop using a vbyesno response to move to the next event, unfortunately I specified it wrong and it is now looping through 8640 cells each requiring me to click yes or no to move on. If I force exit excel I'll lose some unsaved code. Is there a way to stop the macro running?

[GTO]

Try CTRL + Pause keys

[menos]

It didn't work, but then nothing has, and now excel has stopped responding. So I'll have to put it down as a learning experience and will hopefully remember to save as I go in future. Thanks for the speedy response!

[GTO]

I'm sorry that didn't work :-( A total guess, but you might want to use a yes/no/cancel and bail the procedure if cancel is chosen.

[menos]

Ah thanks, good tip. from now on I will use vbyesnocancel