Microsoft Excel
Back to jkp-ads.com

Ron de Bruin
Excel Automation

Microsoft MVP Program

Ribbon Examples files and Tips

Important message to visitors of this page

Ron de Bruin decided to remove all Windows Excel content from his website for personal reasons. If you want to know why, head over to rondebruin.nl.

Luckily, Ron was kind enough to allow me to publish all of his Excel content here.

Most of these pages are slightly outdated and may contain links that don 't work. Please inform me if you find such an error and I'll try to fix it.

Kind regards

Jan Karel Pieterse


Important : Follow the steps on the page first before you start with the examples and tips on this page : Change the Ribbon in Excel 2007 and up

Also check out the index page for Ribbon and QAT stuff : https://jkp-ads.com/rdb/win/section2.htm

Note: If you are a Mac user start here : Change the Ribbon in Mac Excel 2016 and up

 

Download RibbonX examples workbooks

You can download 8 Excel files here with basic RibbonX examples for Excel 2007 and up
Download Example Excel files Last Updated : 10-Jan-2017

1: Add custom group in built-in tab.xlsm
2: Custom tab for Favorite Groups and buttons.xlsm
3: Custom tab for your favorite macros part 1.xlsm
4: Custom tab for your favorite macros part 2.xlsm
5: Dictator(1).xlsm
6: Dictator(2) With_Custom_Tab.xlsm
7: Disable-Visible-Repurposing.xlsm
8: Office Button or Backstage.

When you create your menus with Application.CommandBars in Excel 97-2003 you have code to create the menu and delete the menu. In Excel 2007 and up when you use RibbonX to customize the Ribbon this is different, when you close or deactivate the workbook it will automatic remove your customizations.

The files in the download are working OK in Excel 2007 and up.
If you want to load different RibbonX for Excel 2007 and Excel 2010 and up see :Load different RibbonX when opening file in Excel 2007 or 2010 and up

Note: For example files for changing the Backstage(File) visit my Backstage page

 

Find the Control, Group and Tab names

You see in the RibbonX that I use for example idMso="VisualBasic" to point to a built-in control.But how do you find the names of the controls ?

Download this file from the Microsoft site: Office 2010: Office Fluent User Interface Control Identifiers

Download this file from the Microsoft site: Office 2013: Office Fluent User Interface Control Identifiers

Download this file from the Microsoft site: Office 2016: Office Fluent User Interface Control Identifiers

See also github : https://github.com/OfficeDev/office-fluent-ui-command-identifiers

 

Excel 365 idMso's (9-July-2020), in the example files I duplicate every group in the Ribbon.

Note: Will add the Draw tab soon

Download Excel 365 example files

 

Tip: ContextMenu Add-in created for Office 2010 (seems to work OK in 2013 and 2016)

ContextMenus Add-In for Office 2010 : This Com add-in from Microsoft add the idMso name of the ContextMenu on the bottom of every Context menu(Right click menu's). This is a very easy way for developers to find the idMso of the menu so they can use it in the RibbonX. Note: Only In 2010 and up you can change the ContextMenu's with RibbonX. The add-in also seems to work OK in 2013 and higher. Download Microsoft ContextMenusaddin

See this example page : Customizing Context Menus in Microsoft Excel

 

Find the names of the button images

You can see in the RibbonX that I use imageMso="HappyFace" to use the built-in image I want. But how do you find the names of all the images?

Download this file from the Microsoft site Office 2010 : Icons Gallery

As far as I know there is no Icons Gallery for Office 2013 and 2016.

Or try this add-in from Jim Rech

Control Image Add-in for Excel 2007 and Excel 2010 but also working in 2013 and higher (made by Jim Rech). Jim's add-in displays the images on buttons in the Ribbon (by adding a new tab), he has tried to remove most or all duplicate images and, in the case of Excel 2007, added a few images not in the MS list.
Download it from my site : File date (18-Nov-2015)

 

 Hide/Show the Ribbon/QAT with VBA

You can use this VBA example posted by Jim Rech to Hide/Show the whole Ribbon and the QAT.

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

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

Or you can use this to Toggle the view of the Ribbon and QAT
Application.CommandBars.ExecuteMso "HideRibbon"

Or you can use this to Toggle the view of the Ribbon only
Application.CommandBars.ExecuteMso "MinimizeRibbon"

  

Examples for a dropdown in the Ribbon

You can download a zip file with two basic examples below.

Download dropdown.zip