+ Reply to Thread
Results 1 to 5 of 5

Ribbon not enabled after macro runs

  1. #1
    Registered User
    Join Date
    10-13-2011
    Location
    Jozi, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    93

    Ribbon not enabled after macro runs

    Hi all,

    I have this weird thing going on with one of my macros. I have custom buttons on a custom Ribbon Tab that run various macros. On one particular macro, once run, I cannot immediately access the Ribbon. I have to click another application or the desktop, then back to Excel in order to get the Ribbon to respond.

    Any ideas ?

    NB! I am running O365, so I do have latest Excel and all available updates installed.

    Thanks in advance.

    Kev
    ***------ Coding for Fun ------***

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Ribbon not enabled after macro runs

    Without seeing the macro this is a pointless question.

    Are we supposed to guess what code the macro has?
    It would seem that's the only solution since you're not going to show us.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,367

    Re: Ribbon not enabled after macro runs

    I am sure that Kev will share the code now you've asked for it - let's not assume he won't.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Ribbon not enabled after macro runs

    Shame I had to ask for it.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,367

    Re: Ribbon not enabled after macro runs

    Oh, I agree totally on that!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 06-06-2019, 01:44 AM
  2. Workbooks.Open freezes excel...Macro-enabled and not Macro-enabled :(
    By IndesliciveMelon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2018, 05:48 PM
  3. [SOLVED] Macro runs quick initially then bogs down after a few runs
    By pongmeister in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-19-2017, 02:02 PM
  4. Ribbon / runs macro / activeworkbook
    By sknalodz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-26-2017, 01:31 PM
  5. [SOLVED] Macro runs using F5 but not when clicking custom button on ribbon
    By 6StringJazzer in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 08-11-2017, 09:39 AM
  6. Macro security issue - unable to save as macro enabled sheet
    By agadge123 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-31-2016, 12:36 PM
  7. Macro security issue - unable to save as macro enabled sheet
    By agadge123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2016, 11:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1