Halting a Macro

[James1981]

Hi,

Is there anyway to stop a macro from running in VBA/Excel?

The only thing I can find is Application.Quit but I don't want to close the Workbook...

James

 

[Jooky68]

try using End, this will completely end any code that is running but wont shut down the application. Or you can also use Exit Sub which will end the current macro or sub procedure that you are in.

This help?

 

[combo]

ESC key or a combination {CTRL}+{pause/break} breaks the code execution.
However, if Application.EnableCancelKey is set to xlDisabled, you can't break the code.

combo