Office Ribbon

The Ribbon can be expanded or collapsed by double clicking on a Menu/Tab name in the ribbon.

With VBA, it is possible like so:

application.commandBars.executeMso "HideRibbon"
application.commandBars.executeMso "MinimizeRibbon"

Note: in spite the names HideRibbon and MinimizeRibbon, these command in fact toggles between hidden and shown ribbons and/or menues.

File -> Options -> Customize Ribbon

uicc.exe is the Ribbon Markup Compiler.

The function showRibbon() of the VBA module ExcelHelpers.