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?
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?