Results 1 to 4 of 4

Thread: Quick Access Toolbar disappears

  1. Jan 25th, 2026, 01:25 PM #1
    groston
    groston is offline

    Thread Starter
    Addicted Member
    Join Date
    May 2002
    Posts
    158

    Question Quick Access Toolbar disappears

    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?
    Reply With Quote Reply With Quote
  2. Jan 26th, 2026, 10:28 AM #2
    jdc2000
    jdc2000 is offline
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,525

    Re: Quick Access Toolbar disappears

    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.
    Reply With Quote Reply With Quote
  3. Feb 8th, 2026, 12:40 PM #3
    gigemboy
    gigemboy is offline
    PowerPoster
    Join Date
    Aug 2005
    Location
    College Station, TX
    Posts
    4,521

    Re: Quick Access Toolbar disappears

    Sounds like you might want to look into multi-threading and all the gotchas that come with it.
    Reply With Quote Reply With Quote
  4. Feb 12th, 2026, 07:48 AM #4
    Zvoni
    Zvoni is offline
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    5,261

    Re: Quick Access Toolbar disappears

    Quote Originally Posted by gigemboy View Post
    Sounds like you might want to look into multi-threading and all the gotchas that come with it.
    Definitely NOT from Excel VBA
    Last edited by Zvoni; Tomorrow at 31:69 PM.
    ----------------------------------------------------------------------------------------

    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width