Minimize Ribbon

[ExcelRoy]

Hi all,

could i please ask for a line of code to minimize the ribbon, then to expand the ribbon

Only to minimize and not remove

Many thanks

 

[JoeMo]

Try:

CommandBars.ExecuteMso "MinimizeRibbon"

 

[ExcelRoy]

Hi JoeMo,

Sorry this doesnt work?
I have the following code so far

Private Sub Workbook_Open()
    Application.Goto Cells(1)
    Application.DisplayFormulaBar = False
    Application.DisplayStatusBar = False
    ActiveWindow.DisplayWorkbookTabs = False
    ActiveWindow.DisplayHorizontalScrollBar = False
    ActiveWindow.DisplayVerticalScrollBar = False
    ActiveWindow.DisplayHeadings = False
End Sub

Thanks

 

[JoeMo]

Hi JoeMo,

Sorry this doesnt work?
I have the following code so far

Private Sub Workbook_Open()
    Application.Goto Cells(1)
    Application.DisplayFormulaBar = False
    Application.DisplayStatusBar = False
    ActiveWindow.DisplayWorkbookTabs = False
    ActiveWindow.DisplayHorizontalScrollBar = False
    ActiveWindow.DisplayVerticalScrollBar = False
    ActiveWindow.DisplayHeadings = False
End Sub

Thanks

Put the procedure below in a standard module and then add this line to your Workbook_Open event macro:
Call MinRibbon

Sub MinRibbon()
CommandBars.ExecuteMso "MinimizeRibbon"
End Sub

 

[ExcelRoy]

Hi JoeMo,

many thanks, I take it I just change Minimize to Maximize to unhide

Thanks

 

[ExcelRoy]

Hi JoeMo,

Still not working, may the problem be I am using 2007?

Thanks

 

[JoeMo]

Hi JoeMo,

many thanks, I take it I just change Minimize to Maximize to unhide

Thanks

You are welcome. NO - if the ribbon is minimized, just run the MinRibbon procedure again to maximize it.

 

[JoeMo]

Hi JoeMo,

Still not working, may the problem be I am using 2007?

Thanks

Yes, that's likely your problem - I'm running Excel 2010. Untested, but a possible alternative is to replace the CommandBars.ExecuteMso ... line with this:

Application.SendKeys "^{F1}"

 

[Eric W]

This also may work:

ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"", true )"

Change the true to false to hide it. But it really hides more than the ribbon, the QAT too.

 

[ExcelRoy]

Hi JiMoe,

Maybe I was a bit forward as I cannot seem to get it working, could it be because I am using 2007?

Thanks