Printable View
Thanks to fafalone, I added some code in my Excel VBA routine to stop it when I click the icon I added to my Quick Access Toolbar. No issues, works great. However, I rewrote the overall macro (big time) and now when it runs, the Quick Access Toolbar is not there much of the time. All I see is ‘Microsoft Excel (not responding)’, but the macro is running. Any suggestions to keep the Toolbar visible?
The "Not Responding" can appear if your macro takes a significant amount of time AND there is no DoEvents in it. If it goes long enough, it can crash Excel and/or Windows. This is one of the few times where a DoEvents is needed to prevent this issue.
Sounds like you might want to look into multi-threading and all the gotchas that come with it.
Definitely NOT from Excel VBAQuote:
Originally Posted by gigemboy