Hide or minimize Ribbon but show Quick Accsess Toolbar in VBA code

[joelin]

Hi all,

Is there a way using VBA to minimize the Ribbon in Excel 2007 and
disable maximize for a specific worksheet.

I find a way to hide the ribbon completely using eexecute excel4macro
but it hides even the munu.
I want to hide the ribbon but QAT is show on

thanks,


Sub HideRibbon()

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

End Sub



Sub ShowRibbon()

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

End Sub

 

[Trevor G]

Welcome to the Forum,

If you place this in your workbook where you want to hide the Ribbon. It has to go into the Workbook Event for On Open. To do this:

Open your workbook > Use Alt + F11 to go into VBA > On the left Double click where it states ThisWorkBook > At the top click General and change to Workbook. Add this code

<font face=Courier New><SPAN style="color:#007F00">'Hide the Ribbon</SPAN><br>Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""RIBBON"", FALSE)"</FONT>

If you then want to Display the Ribbon again when the workbook closes. Top right of current screen (Inside ThisWorkBook), Select procedure BeforeClose > Add this code

<font face=Courier New><SPAN style="color:#007F00">'Show the Ribbon</SPAN><br>Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""RIBBON"", TRUE)"</FONT>