Chapter 20
Accessing Your Macros through the User Interface
IN THIS CHAPTER
Discovering how to customize the Ribbon
Adding icons to the Quick Access toolbar
Modifying shortcut menus
The Ribbon is the primary user interface (UI) for Microsoft Office applications — and, for that matter, it’s the primary UI for Windows File Explorer. The Ribbon’s feature-rich set of controls make it an excellent UI. You can use those same controls to launch your macros.
You might expect to be able to create custom Ribbon commands using Visual Basic for Applications (VBA). The bad news is that you can’t use VBA to modify the Ribbon. The good news is that you’re not completely out of luck, because this chapter describes some of the ways to work with Excel’s UI.
Customizing the Ribbon
This section describes ways to customize the Ribbon. You can modify the Ribbon manually, but you can’t make changes to the Ribbon using VBA. It’s sad, but true. For example, if you write an application and you’d like to add a few new buttons to the Ribbon, you need to program those changes outside Excel, using a tool called RibbonX.
Customizing the Ribbon manually
It’s easy to make changes to the Ribbon manually. You ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access