I would like to be able to minimize the ribbon using vba in Excel 2007 and
then return the ribbon before closing the application. Any help would be
appreciated. Thank you!

Hi Maths1

One option is this (only VBA)

Sub HideRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub


Sub ShowRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
End Sub

Another good option is to do it with RibbonX
If you want that post back

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Maths1" wrote in message ...
I would like to be able to minimize the ribbon using vba in Excel 2007 and
then return the ribbon before closing the application. Any help would be
appreciated. Thank you!