CHAPTER 25Customizing the ribbon to run macros
In this chapter, you will:
Learn where to add ribbon code: the customui folder and file
Add controls to a ribbon
Understand the RELS file
Use images on buttons
Troubleshoot error messages
Learn other ways to run a macro
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. The new Excel file is actually a zipped file, containing various files and folders. All you need to do is unzip it, make your changes, and you’re done. Okay, it’s not that simple—a few more steps are involved—but it’s not impossible.
Before beginning, go to the File ...