How to hide top tool-bar/menu with VBA

[behedwin]

How can i hide the top toolbar in excel 2016 with VBA?
I dont want to run it in full-screen. That makes users scared

but i just want to minimize/hide the top-menu/toolbar when a excel-file is opened and restore it when it is closed.

 

[lrobbo314]

Either of these lines of code should do the trick. Then you can call the sub with the workbook_open event.

Sub HideRibbon()
'CommandBars.ExecuteMso "HideRibbon"
CommandBars.ExecuteMso "MinimizeRibbon"
End Sub