PDA

View Full Version : Hide Ribbon Show Only QAT



tengkurap
12-21-2008, 05:04 AM
hi all
I got this code from another site
but i search VBA code for
hide the ribbon but show only quick access toolbar
I can't find the code
can someone help me for the code???
Thank...


Sub HideRibbon()

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"

End Sub



Sub ShowRibbon()

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"

End Sub