Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 26. Customizing the Ribbon to Run Macros

IN THIS CHAPTER

Out with the Old, In with the New	543
Where to Add Your Code: customui Folder and File	544
Creating the Tab and Group	545
Adding a Control to Your Ribbon	546
Accessing the File Structure	552
Understanding the RELS File	553
Renaming the Excel File and Opening the Workbook	553
Using Images on Buttons	554
Converting an Excel 2003 Custom Toolbar to Excel 2007	556
Troubleshooting Error Messages	558
Other Ways to Run a Macro	561
Next Steps	568

Out with the Old, In with the New

One of the first changes you notice when you open Excel 2007 is the new ribbon toolbar. Gone are the menus and toolbars of old. And this change isn’t just visual—the method of modifying custom menu controls has changed just as radically. ...