Halting macros
A running macro can normally be interrupted by pressing CTRL+BREAK on the keyboard. You may however have to close open dialog boxes originating from the macro before this command can be executed.
Information noteThe CTRL+BREAK option can be turned on and off via the Automation calls Application.EnableCtlBrk and Application.DisableCtlBrk.