Excel 2016 VBA and Macros

25. Customizing the Ribbon to Run Macros

In This Chapter

Where to Add Code: The customui Folder and File

Creating a Tab and a Group

Adding a Control to a Ribbon

Accessing the File Structure

Understanding the RELS File

Renaming an Excel File and Opening a Workbook

Using Images on Buttons

Troubleshooting Error Messages

Other Ways to Run a Macro

Next Steps

One of the biggest changes in Excel 2007 was the replacement of command bars and menus with the ribbon, a colorful bar of buttons and drop-downs across the top of the application. Unlike the command bars of old, a ribbon isn’t designed via VBA code. Instead, if you want to modify the ribbon and add your own tab, you need to modify the Excel file itself, which isn’t as impossible as it sounds. ...