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-2016
Also check out the idex page for Ribbon and QAT stuff : http://www.rondebruin.nl/win/section2.htm
Note: If you are a Excel 2016 for Mac user start here : Change the Ribbon in Mac Excel 2016
You can download 8 Excel files here with basic RibbonX examples for Excel
Download Example Excel files Last Updated : 1-May-2016
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
6: Dictator(2) With_Custom_Tab.xlsm
8: Office Button or Backstage.
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-2016 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-2016.
If you want to load different RibbonX for Excel 2007 and Excel 2010-2016 see :Load different RibbonX when opening file in Excel 2007 or 2010/2016
Note: For example files for changing Backstage(File) visit my Backstage page
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 2007: Lists of Control IDs
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
I create my own versions of the files for Excel above to make it easier.
Note: If you disable macros you can't use the files.
When I have time i create a version for Excel 2013
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-2016 you can change the ContextMenu's with RibbonX. The add-in also seems to work OK in 2013 and 2016. Download Microsoft ContextMenusaddin
See this example page : Customizing Context Menus in Microsoft Excel
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
Download this file from the Microsoft site Office 2007 : Icons Gallery
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 two add-ins from Ken Puls and Jim Rech
Identifying your imageMso – Excel, Word & Powerpoint Add-in from Ken Puls, It’s labelled as 2007, but still works in 2010-2016, maybe it is safer to use the 2007 images so its backwards compatible.
Control Image Add-in for Excel 2007 and Excel 2010 but also working in
2013 and 2016
(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
Download it from my site : File date (18-Nov-2015)
Try this Add-in : RibbonX Visual Designer Add-in (made by Andy Pope)
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
Only in Excel 2010-2016 you can use this to hide the view of
only the Ribbon
You can use a function to check the state of the Ribbon in 2007-2016
Sub test() 'Hide Ribbon if it is on the screen in 2010-2016 If RibbonState = 0 Then CommandBars.ExecuteMso "MinimizeRibbon" End Sub Function RibbonState() As Long 'Sascha Trowitzsch: http://www.mosstools.de/ 'Result: 0=normal, -1=autohide RibbonState = (CommandBars("Ribbon").Controls(1).Height < 100) End Function
Note: In Excel 2010-2016 it is no problem anymore to
hide the MRU list, see my backstage page.
There is no built-in option to disable the MRU("Most Recently Used") file list in the Office button menu in 2007. Try this example file that create a new tab on the Ribbon and hide/disable a few controls with RibbonX and with VBA code from Jim Rech disable the MRU list.
Part from the comments in the code from Jim:
Because there is apparently no way to disable the MRU list on the Office Menu directly we clear it by setting Application.RecentFiles.Maximum to 0. Since this action clears the MRU list in the registry we first backup its contents to the registry as well as number of files the user is showing in it. We use the registry in case VB variables are cleared.
Download the example file
You can download a zip file with two basic examples below.