I’ve decided that it is time to start maintaining a Table of Contents for my Ribbon blog posts. It’s just getting a little too hard to find them all.
I’ll keep modifying this page, updating it as I add more and more examples.
Fellow Excel MVP Robert Martin, Access MVP Teresa Hennig and I have written a book called RibbonX – Customizing the Office 2007 Ribbon. This book builds on many of the things discussed on this blog, as well as adds much more material not covered here. Some examples from the book can be seen here:
If you’re interested in seeing more than just Chapter 7, you can buy the book here.
Other Useful Links
Using the CustomUI Editor tool (A free download that you are crazy not to use!)
The Excel 2007 VBA Programmers Reference RibbonX chaper is available for download, and is fantastic. I’d highly recommend giving it a read.
RibbonX development references compliments of Patrick Schmid, OneNote MVP.
Office 2007 Icon Gallery A collection of Add-ins and Global Templates for Excel, Word and Powerpoing, which will help you find the idMso’s of the built in menu commands. (Some more history about the original incarnation of these files can be found here.)
List of Office Control ID’s from Microsoft for all the Office applications. (Read more here.)
MSDN Articles of Interest:
Examples on this blog
- A basic demonstration of creating a button group on the Ribbon, and the VBA procedures needed in order to react to button clicks.
- Several examples of creating buttons on the Ribbon. These examples include:
- Example showing that there are three small buttons to one column of button controls on the Ribbon
- Showing how to add a group to an existing tab (instead of a new one)
- Using large buttons (instead of the normal small ones) on a Ribbon group
- Mixing large and small buttons on one group
- Finding and using Excel’s built in Ribbon images on button controls.
- Shows how to use your own picture on a Ribbon button, rather than just the default images allowed in Microsoft Office.
- An example of creating a checkbox on the Ribbon, and having a VBA message box pop up to tell you which way the checkbox is set.
- An example how to change the value of a Ribbon control (checkbox) from a VBA procedure using a callback, (not from clicking the checkbox itself.)
- Demonstration of using a checkbox to control the visibility of a button on the Ribbon. Contains a detailed walk-through of the setup and order of code execution.
- (Temporarily unavailable)
- Shows how to create a very basic dynamic menu in a Ribbon group.
- An example of using an editBox control to change the name of a button on the Ribbon.
- Using an editBox and a Button to rename worksheets. This article is built around displaying the interaction between the ribbon and application interaction.
- A tutorial in the creation of a RibbonX button, and a complete dissection of the code used to create it. Contains images and explanation to show what each and every piece of the code accomplishes.
Creating a dynamic menu
- This example shows the creation of a menu which lists all Excel files in a directory, and will open the selected file when you click it. It also allows you to change the file path and update the menu to reflect the files in the new path.
Sharing A Ribbon Tab With Multiple Workbooks
- An exploration of creating an Add-in to act as a RibbonUI container, and how to add controls to that tab from a different workbook.
Debugging RibbonX Invalidate/InvalidateControl issues
- Some observations and recommendations to avoid having another add-in conflict with yours.
Examples from other sites:
Ron deBruin’s examples on working with:
Note: If you have examples on your site, and would like them added here, please contact me.