Thread: Minimize 2007 ribbon via VBA?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Minimize 2007 ribbon via VBA?
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

--

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


"Charlotte E" <@ wrote in message ...
How to do it?!?


CE



Reply With QuoteReply With Quote