Loss of Ribbon/Controls after macro runs

Nick Burns

Nick Burns

Member
Joined
May 24, 2017
Messages
162
Reaction score
0
Points
16
Excel Version(s)
Office 365
I have a macro that simply runs some PowerQueries, saves the sheets/tables to a new file and then closes, leaving open the new file.

After which the Ribbon is completely blank. I can get it "refreshed" by viewing the Backstage (ALT-F) and then ESCaping back but doing the same in the macro
SendKeys "%f{ESC}" doesn't help.

Anyone else run into this issue and know of a way to refresh the Ribbon again?
 

Attachments

  • MissingRibbon.PNG
    MissingRibbon.PNG
    9.6 KB · Views: 11
Anyone? Bueller? Bueller?

I've even tried the following without luck:

Code: 
    Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
    Application.Wait (Now + TimeValue("0:00:05"))
    Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",true)"

:help:

​
 
Not come across it myself, but try that code in a macro run from OnTime, doesn't need to be more than a seconds timing.
 
You must log in or register to reply here.
Back
Top