Minimize 2007 ribbon via VBA?

R

Ron de Bruin

You can use this but it also hide the QAT
You must use ribbonx in the file if you want to see the QAT (post back if you want a example)

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


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

Charlotte E

Hi Ron,


Sorry for a late reply - got my head in this XL2007 all day :)


Got it working - thanks :)
 
Ã

ãƒã‚¤ãƒ‰ãƒ³

Hi! Different person here, but could you please give an example of using
ribbonx to show the QAT while hiding the ribbon.

Thanks,
 
Top