Minimize the ribbon in Excel 2007 using code

M

Maths1

I would like to be able to minimize the ribbon using vba in Excel 2007 and
then return the ribbon before closing the application. Any help would be
appreciated. Thank you!
 
R

Ron de Bruin

Hi Maths1

One option is this (only VBA)

Sub HideRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub


Sub ShowRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
End Sub

Another good option is to do it with RibbonX
If you want that post back
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Macro to create 2003 style menus in 2007 and above 1
Displaying Data Forms in Excel 2016 for Mac 0
Err50289 Dynamic Ribbon in Protected Project 0
Minimize Ribbon 0
Code to Minimize the riboon 3
Problem in adding macro to ribbon through Add-in 7
Excel 2007 Ribbon Will Not Re-Validate Unless Excel Window Has Focus 0
Hide Ribbon In XLS Workbook When Using Excel 2007 12

Top