'Stop Running Macro other than ESC / Command +
How do I stop a running macro in Mac Excel 2016 (version 15)?
I tried:
Command + .
Esc
Esc x2
Application.EnableCancelKey = xlInterrupt, doesn't make any difference.
Solution 1:[1]
As suggested by jsotola, use DoEvents to have Excel handle keypress, then hold Command + . to interrupt it.
Thanks for the help jsotola!
Solution 2:[2]
Make sure you are on VBA/ExcelVBA window and then Try below steps:
Step 1-- Menu bar -> Run -> Reset
Step 2-- Menu bar -> Run -> Break
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Dennis Lau |
| Solution 2 | meMadhav |
