allow break [Ctrl-Break or similar] of long-running opeartions/calculations that lock Excel
Well-written VBA code may still (in some cases) take a long time to run, and (again, if well written) can be paused or stopped using Ctrl-break.
There are a multitude of ways users can intentionally or unintentionally trigger long-running, CPU intensive Excel (worksheet) operations, with no apparent recourse to pause or stop, either because the action was an accident (auto filling a complex formula across a very large data set), or the user has some other task that comes up and needs to take priority.
AFAIK, the only option is to either wait for Excel to finish the activity, or use task manager to kill Excel, potentially losing any unsaved work, and certainly being an inelegant solution.
Given that Ctrl-Break works for VBA, I can't help but wonder how difficult it would be to apply the same command to all of Excel.... if Excel is actively processing, just interrupt the process and give the user two choices: continue the operation, or "return" to the original state, essentially using the undo stack to the last point.
Thanks for reading!