VBA to minimize ribbon with SendKeys

Question

As described in the solution here I created the following VBA to minimize the ribbon menu in Excel:

Sub Minimize_Ribbon()
SendKeys "^{F1}"
End Sub

However, when I run this VBA it opens the following link to the Help section from Microsoft:
https://learn.microsoft.com/de-de/office/vba/api/overview/language-reference?redirectedfrom=MSDN

I assume this issue is because somewhow the ^ which should run the Ctrl is not working in the VBA.
What do I need to change to make it work correctly?

or `CommandBars.ExecuteMso "HideRibbon"` if you want to completely hide it. — Siddharth Rout, Dec 17 '19 at 09:02
Actually `SendKeys` is always the worst solution (if there are other options). — Pᴇʜ, Dec 17 '19 at 09:03
With `Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon""," & "False)"` you _really_ hide the toolbar ;-) — Storax, Dec 17 '19 at 09:09

score 0 · Accepted Answer · answered Dec 20 '19 at 07:07

0

As already described in the comments the solution is:

Sub Minimize_Ribbon()
CommandBars.ExecuteMso "MinimizeRibbon"
End Sub

answered Dec 20 '19 at 07:07

Michi

4,663
6
33
83

VBA to minimize ribbon with SendKeys

1 Answers1