Forum Discussion
How can I interrupt a long-running macro in Excel 360 on a Mac?
Any thoughts? The interwebs are strangely silent on the matter.
Just want to kill it, but preferably not blow away Excel itself. All the toolbar buttons are grey or unresponsive. Excel reports 100% cpu (one of them I presume - the others are presumably shooting hoops or reading Schopenhauer while they wait for something useful to do.)
Excel is 16.47.1 (probably the lastest Excel from Microsoft 365)
Mac OS is Mojave.
Try pressing Esc or Command+. (point)
If that doesn't work, Excel is executing a "tight" loop that can only be interrupted by quitting Excel.
4 Replies
Try pressing Esc or Command+. (point)
If that doesn't work, Excel is executing a "tight" loop that can only be interrupted by quitting Excel.
- Yep - tried both of those. I have yet to find a situation where they actually do something.
Having to blow up Excel to stop a macro seems a bit 20th Century. They should get an intern to work or the problem as a holiday project...
Thanks for the help, though. It gives some reassurance that the problem is at their end rather than at my end.You can insert a line
DoEvents
inside a loop. This will slow down execution slightly, but it will ensure that you can interrupt code execution by pressing Command+. or Esc.
