I’ve been using the Excel 2007 beta for quite a while. Customizing the new ribbon UI has always been a mystery. Until today. If you’re interested in learning how to customize Excel 2007’s user interface, follow these steps:
- Read Savraj Dhanjal’s brief article: Ribbon Extensibility: A VBA Sample, and then download the RxDemo.xlsm file.
- Go to OpenXML Developer, and download the Custom UI Editor Tool.
- Open the RxDemo.xlsm file using the Editor Tool.
- Study it, and then experiment on your own.
I’m encouraged. Creating a new tab to house my PUP v7 tools should be a piece of cake. Well, not quite. It’s probably about 10 times more complicated than using the old CommandBar object model, but at least it’s do-able.