On open, the ribbon would then be shown again. This eliminates the chance of hiding the ribbon when the workbook is opened and a user then manually showing the ribbon which in turn would reverse the show on close and actually hide the ribbon.

If CommandBars('Ribbon').Controls(1).Height 100 ThenĬommandBars.ExecuteMso ('MinimizeRibbon') I call this macro on Workbook_Open to check for the ribbon and if not hidden, it will hide the ribbon (I actually have it located in another Sub that also removes the formula bar, status bar, headings, and gridlines at Workbook_Open). If you want a full list of all the idMSO in excel, click the following that apply to you: Excel 2013+, Excel 2010, Excel 2007 In other words, the following code would make no visual change at all when ran because the idMSO 'HideRibbon' is a toggleButton: Sub HideTheRibbon()

If you want the window to revert back to normal, you run the exact same code again. If you want the ribbon automatically hidden when the workbook opens, put this in the workbook code: Sub Workbook_Open()Īlternatively, to achieve the same thing, you could put this code in a module: Sub Auto_Open() Will make your window look like this, in the maxamized window size (just like what would happen if you were to press the Auto-Hide Ribbon button manually): Running the following code: Sub HideTheRibbon() This code makes my excel window look like everything is gone the same way the first option does for Auto-Hide Ribbon.īefore the code runs, my window looks like this, in the 'Restore' size: This isn't a workaround, this is the actual idMSO for what I think you're looking for. I can't see that anyone else has brought this up. Moreover, it is supposed to imitate the attempt 2. It switches to the second option displayed in the picture Show Tabs. This keeps the blue icon but does not hide the entire menu. I have tried hints shown in this thread: VBA minimize ribbon in ExcelĪttempt 1 Application.ExecuteExcel4Macro 'Show.ToolBar(''Ribbon'',False)Īttempt 2 CommandBars.ExecuteMso 'MinimizeRibbon' Important thing for me is to keep in the Excel menu the upper arrow icon (marked with blue). I would be also interested in VBA switching back to the third option Show Tabs and Commands. How to Auto-hide Ribbon in Excel 2013 in VBA? I would like to achieve exactly what I get by clicking on the upper arrow icon at the right top of Excel menu marked with blue in the picture below and then clicking on the first option marked with orange:

Enable macros in mac excel 2013