Change the Ribbon in Excel 2007 or Excel 2010
Things we must do and understand before we start
If you want to change the Ribbon in Excel 2007 or Excel 2010 you must add RibbonX(xml)
to a file named customUI.xml and/or customUI14.xml that is inside your Excel file.
What, files that are inside a Excel file ?.
Excel 2007-2010 files are really zip files so if you change the extension to zip and open
the file in your zip program you see that there are a few folders and a file inside the zip.
If you want a easy way to insert RibbonX into a Excel 2007-2010 workbook, then I suggest you
download and install the new version of the Custom UI Editor here:
http://openxmldeveloper.org/archive/2006/05/26/CustomUIeditor.aspx
Important for Win XP users : Before you install the Custom UI Editor do this:
Run Windows Update, and in Optional Updates pick .NET framework 2 or 3.
After you installed it, run Windows Update again to see if there are patches for it.
This version of the Custum UI Editor gives you an option to insert a customUI.xml file for Excel 2007-2010
and/or a customUI14.xml file only for Excel 2010 into your 2007-2010 workbook.
When you do not want to work with new stuff from Excel 2010 (like Backstage View for example), then you can
use the Office 2007 Custom UI Part option to add your RibbonX to workbooks that you use in Excel 2007
and Excel 2010. If there is no customUI14.xml file when you open the workbook in Excel 2010, it will load
the customUI.xml file.
But if you want to insert (for example) a button in the Office Button menu when you open your file in Excel 2007 and a button in Backstage View when you open the workbook in Excel 2010, then you must insert the RibbonX in both the xml files with the Custum UI Editor. See this page for a example :
http://www.rondebruin.nl/ribbonx20072010.htm
Open the Custom UI Editor.
You see that there are 5 menu buttons on the toolbar menu in the UI editor.
Open : Open the Excel file that you want to edit (change the Ribbon for this file)
Save : Save the RibbonX in the file that you have open in the UI editor
(not possible to save when the file is open in Excel)
Insert Icons : Insert your own icons in the file (icons will be saved in the file)
Validate : Validate your RibbonX so you are sure that there are no typos
Generate Callbacks : This will create macros(callbacks) for each onAction you have in
the RibbonX. Select all callbacks and copy them in a normal module in your workbook.
When you open a Excel file in the Custom UI Editor you can right click on the file name and choose :
Office 2007 Custom UI Part Or use Office 2010 Custom UI Part
Or you can use the Insert menu to choose one of the two options.
It creates the customUI14.xml file if you choose Office 2010 Custom UI Part and
the customUI.xml file if you choose Office 2007 Custom UI Part. After you choose
one option or both, you can enter or paste your RibbonX in the right window.
First example
This example add RibbonX that create a button on the Home tab when you open your
file in Excel 2007 or in Excel 2010. Because we not use something new for 2010 we can
add the RibbonX only to the customUI.xml file ("Office 2007 Custom UI Part") .
1: Open a new workbook and save it as Book1.xlsm (Excel Macro-Enabled workbook)
2: Close the workbook
3: Open Book1.xlsm in the Custom UI Editor
4: Right click on the File name in the Custom UI Editor or use the Insert menu
5: Choose "Office 2007 Custom UI Part" to create the customUI.xml file
6: Paste the RibbonX below in the right window
Note: If there is no customUI14.xml file it will load the customUI.xml also in Excel 2010.
7: Save your changes in the Custom UI Editor (click on the Save button)
8: Close the Editor
9: Open the File in Excel
10: Alt F11
11: Insert Module
12: Copy the macro below in the Module
14: use Alt q to close the VBA editor
15: Test the workbook in 2007 and/or in 2010
More RibbonX examples (Example workbooks)
You can download 9 Excel files here with basic RibbonX examples.
Download Example Excel files
XL-Add custom group in built-in tab.xlsm
XL-Add custom tab for Favorite Groups and buttons.xlsm
XL-Add menu and buttons to the Office Button.xlsm
XL-Custom tab for your favorite macros part 1.xlsm
XL-Custom tab for your favorite macros part 2.xlsm
XL-Custom tab for your favorite macros Part 2.xlsm
XL-Dictator(A).xlsm
XL-Dictator(B) With_Custom_Tab.xlsm
XL-Dictator(C) Only_QAT.xlsm
XL-Disable-Visible-Repurposing.xlsm
Note 1: 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-2010 when you use RibbonX to customize the ribbon this is different, when you close or deactivate the workbook it will automatic remove your customizations.
Note 2: The files are working OK in Excel 2007 and 2010.
If you want to load different RibbonX for Excel 2007 and Excel 2010 see :
Load different RibbonX when opening file in Excel 2007 or 2010
http://www.rondebruin.nl/ribbonx20072010.htm
Backstage view in Excel 2010
http://www.rondebruin.nl/backstage.htm
Change the Ribbon with RibbonX and VBA code (Example workbooks)
Example 1: Hide Disable or Display Enable Ribbon controls/groups/Tabs with VBA
In one of the 9 Excel files above you can find RibbonX examples to
Hide Disable or Display Enable Ribbon controls/groups/Tabs.
But how can you Hide or make a Tab, Group or Control visible with VBA code ?
My MSDN Articles :
Display and Hide Tabs, Groups, and Controls on the Microsoft Office Ribbon (Part 1 of 2)
http://msdn.microsoft.com/en-us/library/ee390805(office.11).aspx
Display and Hide Tabs, Groups, and Controls on the Microsoft Office Ribbon (Part 2 of 2)
http://msdn.microsoft.com/en-us/library/ee633442(office.11).aspx
Or from my own site :
Hide or Display Custom Ribbon Tab/Group/Control with getVisible
http://www.rondebruin.nl/hidevisible.htm
Example 2 : How do I fill a dropdown on the Ribbon with values from a range ?
In the download you find one file from Jim Rech and one from me
based on Jim's example. I my example you can see how you can
use the dropdown value in another macro.
Download DropDown.zip
Find the Control, Group and Tab names
You see that I use idMso="VisualBasic" to point to a built-in control.
But how do you find the names of the controls ?
Option 1: Download this Microsoft file to find the names of all controls in Office 2007
2007 Office System Document: Lists of Control IDs
Between the 24 files you can find a file called ExcelRibbonControls.
Option 2: I create my own version of the Excel file for 2007 above to make it easier
Download the Excel 2007 version
Note: If you disable macros you can't use this file.
This version is for Excel 2010
Download the Excel 2010 version
Download the Word and PowerPoint version for Excel 2007 :
Download the Word version
Download the PowerPoint version
If you are only looking for the names of controls in the built-in groups on the Ribbon in 2007 see :
http://www.rondebruin.nl/xmlribbongroups.htm
Find the names of the button images
You can see that I use imageMso="HappyFace" to use the built-in image I want.
But how do you find the names of the images?
Option 1: Jim Rech has done an add-in showing the Office 2007 button images.
According to Jim his add-in removes most or all duplicate images, adds some that the others
don't have and displays the images on actual buttons on the ribbon (by adding a new tab).
When you click a control its name is copied to the clipboard for pasting into RibbonX.
Download it from my site File date (24-Jan-2008)
There is one small problem on this moment when you use this add-in:
If you select “All Commands” In the “Choose commands from” dropdown in the QAT customize dialog with this add-in loaded you will get a error 400 a lot of times (you can hold the Enter key, faster than clicking OK).
Option 2: Use John Walkenbach's mso image browser for excel 2007 workbook.
Download it from my site
Option 3: Download this file from the Microsoft site Office 2007 : Icons Gallery
RibbonX Tips
Tip : Try this add-in : RibbonX Visual Designer Add-in (Andy Pope) New
http://www.andypope.info/vba/ribboneditor.htm
Now that you know how you can use the Custom UI Editor to save the RibbonX in a workbook
maybe you want to try this workbook to create the RibbonX for a custom tab on the ribbon.
XMLCreator-1.5 File date: 5 March 2007
Use your own icons in the Ribbon
<--- ron.png
1) Download my picture ron.png on your desktop (right click on the picture and use Save Picture As)
2) Open the file "Book1.xlsm" from the first example in the Custom UI Editor.
3) Click on the Insert Icons button or use the Insert menu to insert the file ron.png.
You see it now below the custumUI file in the Custom UI Editor, maybe you must click on the +
before customUI.xml if you not see it.
Then change this
imageMso="HappyFace"
To
image="ron"
Click on the Save button in the Custom UI Editor and open the file "Book1.xlsm"
in Excel and you see my nice face on the ribbon.
imageMso = Built-in icon
image = Your own icon
See also this pages for more information
Images on custom Ribbon controls
http://www.rondebruin.nl/getimage.htm
Add buttons to the QAT and customize the images of the buttons
http://www.rondebruin.nl/imageqat.htm
Creating Custom Ribbon Galleries in Excel 2007 (my MSDN article)
http://msdn.microsoft.com/en-us/library/dd756403.aspx
Galleries in the Ribbon (my own site)
http://www.rondebruin.nl/galleries.htm
Dictator examples and Hide the MRU("Most Recently Used") file list in 2007
There are three dictator examples in example files but you see that the MRU list is still there.
Note: in Excel 2010 this is no problem anymore, see this page for a example
http://www.rondebruin.nl/backstage.htm
There is no built-in option to disable the MRU("Most Recently Used") file list in the Office button menu.
Try this example file with RibbonX to create a new tab on the Ribbon and hide/disable a
few controls and VBA code from Jim Rech to 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
Please give feedback if you have problems or suggestions with the code.
If you test the Dictator examples you also notice that it will not disable/hide everything.
With VBA code you must also hide the formula bar, status bar and right click menus.
Hide/Show the whole Ribbon with VBA
You can use this VBA example posted by Jim Rech to Hide/Show the whole ribbon.
RibbonX templates for the Sample XML menu in the UI editor
On the Insert menu in the Custom UI Editor you see that there is a menu called "Sample XML"
It is easy to have your own menu templates there so you can insert it quick in any workbook you want.
You only have to make a few changes after you insert it from the Sample menu and you are ready.
But In the UI editor you cannot save the RibbonX directly to an xml file and use that in the
Insert>Sample XML menu. It is only possible to save the RibbonX directly in a Excel file.
But you can do this:
Make your template menu in the UI editor and validate and test the RibbonX in a test workbook.
Then copy the RibbonX in a Notepad file and save it with the name you want.
Then change the extension from txt to xml
If you not see the extensions of your files do this:
1: Open Windows Explorer
2: Win XP : Click on Tools>Folder Options
3: Vista : Click on Organize>Folder and Search Options
4: On the View tab uncheck “Hide extensions for known file types"
Then copy the template xml file in the samples folder.
C:\Program Files\CustomUIEditor\Samples
Or if you have a 64 bit machine
C:\Program Files (x86)\CustomUIEditor\Samples
After you open the UI editor you will see your template file in the Sample menu of the UI editor
and you can insert it in any workbook you want.
You can download a zip file here with 9 XML files with RibbonX from the example workbooks that you can
download in the "More RibbonX examples" section so you can paste them in the "Samples" folder to test it.
XMLSamples.zip
File date: 19-Oct-2008 (9 examples to insert in the "Office 2007 Custom UI Part")
More information
See the links on this part "Excel 2007 Ribbon and QAT pages" or "Excel 2010 beta" of my Tips page
http://www.rondebruin.nl/tips.htm
Customizing the 2007 Office Fluent Ribbon for Developers (MSDN)
http://msdn2.microsoft.com/en-us/library/aa338202.aspx
Read Chapter 14 (RibbonX) of this great book: Excel 2007 VBA Programmer's Reference
http://www.oaltd.co.uk/Excel2007ProgRef/Default.htm
Book: RibbonX: Customizing the Office 2007 Ribbon
http://www.amazon.com/RibbonX-Customizing-Office-2007-Ribbon/dp/0470191112
RibbonX Visual Designer Add-in (Andy Pope) New
http://www.andypope.info/vba/ribboneditor.htm
Look on Patrick Schmid’s site for a forum and an Add-in and more great stuff.
http://pschmid.net/index.php
If you want to change the Ribbon in Excel 2007 or Excel 2010 you must add RibbonX(xml)
to a file named customUI.xml and/or customUI14.xml that is inside your Excel file.
What, files that are inside a Excel file ?.
Excel 2007-2010 files are really zip files so if you change the extension to zip and open
the file in your zip program you see that there are a few folders and a file inside the zip.
If you want a easy way to insert RibbonX into a Excel 2007-2010 workbook, then I suggest you
download and install the new version of the Custom UI Editor here:
http://openxmldeveloper.org/archive/2006/05/26/CustomUIeditor.aspx
Important for Win XP users : Before you install the Custom UI Editor do this:
Run Windows Update, and in Optional Updates pick .NET framework 2 or 3.
After you installed it, run Windows Update again to see if there are patches for it.
This version of the Custum UI Editor gives you an option to insert a customUI.xml file for Excel 2007-2010
and/or a customUI14.xml file only for Excel 2010 into your 2007-2010 workbook.
When you do not want to work with new stuff from Excel 2010 (like Backstage View for example), then you can
use the Office 2007 Custom UI Part option to add your RibbonX to workbooks that you use in Excel 2007
and Excel 2010. If there is no customUI14.xml file when you open the workbook in Excel 2010, it will load
the customUI.xml file.
But if you want to insert (for example) a button in the Office Button menu when you open your file in Excel 2007 and a button in Backstage View when you open the workbook in Excel 2010, then you must insert the RibbonX in both the xml files with the Custum UI Editor. See this page for a example :
http://www.rondebruin.nl/ribbonx20072010.htm
Open the Custom UI Editor.
You see that there are 5 menu buttons on the toolbar menu in the UI editor.
Open : Open the Excel file that you want to edit (change the Ribbon for this file)
Save : Save the RibbonX in the file that you have open in the UI editor
(not possible to save when the file is open in Excel)
Insert Icons : Insert your own icons in the file (icons will be saved in the file)
Validate : Validate your RibbonX so you are sure that there are no typos
Generate Callbacks : This will create macros(callbacks) for each onAction you have in
the RibbonX. Select all callbacks and copy them in a normal module in your workbook.
When you open a Excel file in the Custom UI Editor you can right click on the file name and choose :
Office 2007 Custom UI Part Or use Office 2010 Custom UI Part
Or you can use the Insert menu to choose one of the two options.
It creates the customUI14.xml file if you choose Office 2010 Custom UI Part and
the customUI.xml file if you choose Office 2007 Custom UI Part. After you choose
one option or both, you can enter or paste your RibbonX in the right window.
First example
This example add RibbonX that create a button on the Home tab when you open your
file in Excel 2007 or in Excel 2010. Because we not use something new for 2010 we can
add the RibbonX only to the customUI.xml file ("Office 2007 Custom UI Part") .
1: Open a new workbook and save it as Book1.xlsm (Excel Macro-Enabled workbook)
2: Close the workbook
3: Open Book1.xlsm in the Custom UI Editor
4: Right click on the File name in the Custom UI Editor or use the Insert menu
5: Choose "Office 2007 Custom UI Part" to create the customUI.xml file
6: Paste the RibbonX below in the right window
Note: If there is no customUI14.xml file it will load the customUI.xml also in Excel 2010.
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<tabs>
<tab idMso="TabHome" >
<group id="customGroup1" label="My Group" insertAfterMso="GroupEditingExcel">
<button id="customButton1" label="Click Me" size="large"
onAction="Macro1" imageMso="HappyFace" />
</group>
</tab>
</tabs>
</ribbon>
</customUI>
7: Save your changes in the Custom UI Editor (click on the Save button)
8: Close the Editor
9: Open the File in Excel
10: Alt F11
11: Insert Module
12: Copy the macro below in the Module
Sub Macro1(control As IRibbonControl)
MsgBox "Hi There"
End Sub
13: Click on the Save button in the VBA editor14: use Alt q to close the VBA editor
15: Test the workbook in 2007 and/or in 2010
More RibbonX examples (Example workbooks)
You can download 9 Excel files here with basic RibbonX examples.
Download Example Excel files
XL-Add custom group in built-in tab.xlsm
XL-Add custom tab for Favorite Groups and buttons.xlsm
XL-Add menu and buttons to the Office Button.xlsm
XL-Custom tab for your favorite macros part 1.xlsm
XL-Custom tab for your favorite macros part 2.xlsm
XL-Custom tab for your favorite macros Part 2.xlsm
XL-Dictator(A).xlsm
XL-Dictator(B) With_Custom_Tab.xlsm
XL-Dictator(C) Only_QAT.xlsm
XL-Disable-Visible-Repurposing.xlsm
Note 1: 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-2010 when you use RibbonX to customize the ribbon this is different, when you close or deactivate the workbook it will automatic remove your customizations.
Note 2: The files are working OK in Excel 2007 and 2010.
If you want to load different RibbonX for Excel 2007 and Excel 2010 see :
Load different RibbonX when opening file in Excel 2007 or 2010
http://www.rondebruin.nl/ribbonx20072010.htm
Backstage view in Excel 2010
http://www.rondebruin.nl/backstage.htm
Change the Ribbon with RibbonX and VBA code (Example workbooks)
Example 1: Hide Disable or Display Enable Ribbon controls/groups/Tabs with VBA
In one of the 9 Excel files above you can find RibbonX examples to
Hide Disable or Display Enable Ribbon controls/groups/Tabs.
But how can you Hide or make a Tab, Group or Control visible with VBA code ?
My MSDN Articles :
Display and Hide Tabs, Groups, and Controls on the Microsoft Office Ribbon (Part 1 of 2)
http://msdn.microsoft.com/en-us/library/ee390805(office.11).aspx
Display and Hide Tabs, Groups, and Controls on the Microsoft Office Ribbon (Part 2 of 2)
http://msdn.microsoft.com/en-us/library/ee633442(office.11).aspx
Or from my own site :
Hide or Display Custom Ribbon Tab/Group/Control with getVisible
http://www.rondebruin.nl/hidevisible.htm
Example 2 : How do I fill a dropdown on the Ribbon with values from a range ?
In the download you find one file from Jim Rech and one from me
based on Jim's example. I my example you can see how you can
use the dropdown value in another macro.
Download DropDown.zip
Find the Control, Group and Tab names
You see that I use idMso="VisualBasic" to point to a built-in control.
But how do you find the names of the controls ?
Option 1: Download this Microsoft file to find the names of all controls in Office 2007
2007 Office System Document: Lists of Control IDs
Between the 24 files you can find a file called ExcelRibbonControls.
Option 2: I create my own version of the Excel file for 2007 above to make it easier
Download the Excel 2007 version
Note: If you disable macros you can't use this file.
This version is for Excel 2010
Download the Excel 2010 version
Download the Word and PowerPoint version for Excel 2007 :
Download the Word version
Download the PowerPoint version
If you are only looking for the names of controls in the built-in groups on the Ribbon in 2007 see :
http://www.rondebruin.nl/xmlribbongroups.htm
Find the names of the button images
You can see that I use imageMso="HappyFace" to use the built-in image I want.
But how do you find the names of the images?
Option 1: Jim Rech has done an add-in showing the Office 2007 button images.
According to Jim his add-in removes most or all duplicate images, adds some that the others
don't have and displays the images on actual buttons on the ribbon (by adding a new tab).
When you click a control its name is copied to the clipboard for pasting into RibbonX.
Download it from my site File date (24-Jan-2008)
There is one small problem on this moment when you use this add-in:
If you select “All Commands” In the “Choose commands from” dropdown in the QAT customize dialog with this add-in loaded you will get a error 400 a lot of times (you can hold the Enter key, faster than clicking OK).
Option 2: Use John Walkenbach's mso image browser for excel 2007 workbook.
Download it from my site
Option 3: Download this file from the Microsoft site Office 2007 : Icons Gallery
RibbonX Tips
Tip : Try this add-in : RibbonX Visual Designer Add-in (Andy Pope) New
http://www.andypope.info/vba/ribboneditor.htm
Now that you know how you can use the Custom UI Editor to save the RibbonX in a workbook
maybe you want to try this workbook to create the RibbonX for a custom tab on the ribbon.
XMLCreator-1.5 File date: 5 March 2007
Use your own icons in the Ribbon
<--- ron.png1) Download my picture ron.png on your desktop (right click on the picture and use Save Picture As)
2) Open the file "Book1.xlsm" from the first example in the Custom UI Editor.
3) Click on the Insert Icons button or use the Insert menu to insert the file ron.png.
You see it now below the custumUI file in the Custom UI Editor, maybe you must click on the +
before customUI.xml if you not see it.
Then change this
imageMso="HappyFace"
To
image="ron"
Click on the Save button in the Custom UI Editor and open the file "Book1.xlsm"
in Excel and you see my nice face on the ribbon.
imageMso = Built-in icon
image = Your own icon
See also this pages for more information
Images on custom Ribbon controls
http://www.rondebruin.nl/getimage.htm
Add buttons to the QAT and customize the images of the buttons
http://www.rondebruin.nl/imageqat.htm
Creating Custom Ribbon Galleries in Excel 2007 (my MSDN article)
http://msdn.microsoft.com/en-us/library/dd756403.aspx
Galleries in the Ribbon (my own site)
http://www.rondebruin.nl/galleries.htm
Dictator examples and Hide the MRU("Most Recently Used") file list in 2007
There are three dictator examples in example files but you see that the MRU list is still there.
Note: in Excel 2010 this is no problem anymore, see this page for a example
http://www.rondebruin.nl/backstage.htm
There is no built-in option to disable the MRU("Most Recently Used") file list in the Office button menu.
Try this example file with RibbonX to create a new tab on the Ribbon and hide/disable a
few controls and VBA code from Jim Rech to 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
Please give feedback if you have problems or suggestions with the code.
If you test the Dictator examples you also notice that it will not disable/hide everything.
With VBA code you must also hide the formula bar, status bar and right click menus.
Hide/Show the whole Ribbon with VBA
You can use this VBA example posted by Jim Rech to Hide/Show the whole ribbon.
Sub HideRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub
Sub ShowRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
End Sub
RibbonX templates for the Sample XML menu in the UI editor
On the Insert menu in the Custom UI Editor you see that there is a menu called "Sample XML"
It is easy to have your own menu templates there so you can insert it quick in any workbook you want.
You only have to make a few changes after you insert it from the Sample menu and you are ready.
But In the UI editor you cannot save the RibbonX directly to an xml file and use that in the
Insert>Sample XML menu. It is only possible to save the RibbonX directly in a Excel file.
But you can do this:
Make your template menu in the UI editor and validate and test the RibbonX in a test workbook.
Then copy the RibbonX in a Notepad file and save it with the name you want.
Then change the extension from txt to xml
If you not see the extensions of your files do this:
1: Open Windows Explorer
2: Win XP : Click on Tools>Folder Options
3: Vista : Click on Organize>Folder and Search Options
4: On the View tab uncheck “Hide extensions for known file types"
Then copy the template xml file in the samples folder.
C:\Program Files\CustomUIEditor\Samples
Or if you have a 64 bit machine
C:\Program Files (x86)\CustomUIEditor\Samples
After you open the UI editor you will see your template file in the Sample menu of the UI editor
and you can insert it in any workbook you want.
You can download a zip file here with 9 XML files with RibbonX from the example workbooks that you can
download in the "More RibbonX examples" section so you can paste them in the "Samples" folder to test it.
XMLSamples.zip
File date: 19-Oct-2008 (9 examples to insert in the "Office 2007 Custom UI Part")
More information
See the links on this part "Excel 2007 Ribbon and QAT pages" or "Excel 2010 beta" of my Tips page
http://www.rondebruin.nl/tips.htm
Customizing the 2007 Office Fluent Ribbon for Developers (MSDN)
http://msdn2.microsoft.com/en-us/library/aa338202.aspx
Read Chapter 14 (RibbonX) of this great book: Excel 2007 VBA Programmer's Reference
http://www.oaltd.co.uk/Excel2007ProgRef/Default.htm
Book: RibbonX: Customizing the Office 2007 Ribbon
http://www.amazon.com/RibbonX-Customizing-Office-2007-Ribbon/dp/0470191112
RibbonX Visual Designer Add-in (Andy Pope) New
http://www.andypope.info/vba/ribboneditor.htm
Look on Patrick Schmid’s site for a forum and an Add-in and more great stuff.
http://pschmid.net/index.php