Hide ribbon / Tabs in Excel with VBA

[elmo2000]

Hi there,

I found

Sub Workbook_Open()
Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",False)"
End Sub

To hide the entire Ribbon on start up of the workbook. Works perfect.
But I want to have the save and print options visible.
Do you guys have any solution for that?

Tx!

 

[CalcSux78]

From VoG's post#2: https://www.mrexcel.com/forum/excel...-but-show-quick-accsess-toolbar-vba-code.html

Not ideal but it works

Sub hide_unhide_Ribbons()
Application.SendKeys ("^{F1}")
End Sub

 

[CalcSux78]

Alternate method:

Not sure if you've ever played with XML and ribbon editing, but you could use this as your custom XML for the file to get the desired effects.

NOTE: Remove all of the periods and change | to / before using... (I had to add to get it to post)


<!--
Hide everything on the ribbon (but the File tab called 'backstage', which will be empty).
Show the Quick Access Toolbar (QAT) with the Save and QuickPrint visible.
Tested on Excel 2010. No VBA code needed.

Insert below XML with the Custom UI Editor into an Office document:
http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2009/08/06/7293.aspx
Tutorial: http://www.rondebruin.nl/win/s2/win001.htm
-->
<.customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<.ribbon startFromScratch="true">
<.qat>
<.sharedControls>
<.control idMso="FileSave" visible="true"/>
<.control idMso="FilePrintQuick" visible="true"/>
<|sharedControls>
<|qat>
<.tabs >
<.tab idMso="TabHome" visible="false"/>
<.tab idMso="TabInsert" visible="false"/>
<.tab idMso="TabPageLayoutExcel" visible="false"/>
<.tab idMso="TabFormulas" visible="false"/>
<.tab idMso="TabData" visible="false"/>
<.tab idMso="TabReview" visible="false"/>
<.tab idMso="TabView" visible="false"/>
<.tab idMso="TabAddIns" visible="false"/>
<.tab idMso="TabPrintPreview" visible="false"/>
<|tabs >
<|ribbon. >
<|customUI.>

To download the Custom UI Editor: http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2009/08/06/7293.aspx

For info on how it works: http://www.rondebruin.nl/win/s2/win001.htm