Programming/Customizing the Excel 2007 Ribbon Using VBA

The Office 2007 Ribbon is a huge change in the user interface from the CommandBars of Office versions 2003 and earlier. However, the VBA programmer will be pleased to learn that using .NET or Visual Studio Tools for Office (VSTO) is not a requirement to control the Ribbon programmatically. In fact, although Ribbon customization requires the use of XML, which definitely is a big change, Ribbon Extensibility ("RibbonX") is actually easier to manipulate using VBA.

Continue Reading: Programming/Customizing the Excel 2007 Ribbon Using VBA »