Working with the Ribbon
Michael Alexander, Dick Kusleika · 2016
This chapter Looks at the Excel Ribbon UI from a user's perspective and customizes the Ribbon with RibbonX code. The Ribbon is made up of a hierarchy of tabs, groups, and controls. Each tab consists of one or more groups and each group consists of one or more controls. One of the most interesting Ribbon controls is the dynamicMenu control. This control lets the Visual Basic for Applications (VBA) code feed XML data into the control. Excel provides a couple of ways to add the macros to the Ribbon. The simplest way to use the Ribbon to execute the code is to add the macro to a custom group using Excel's Customize Ribbon interface. Another method for accessing the macros is to add them to the Quick Access Toolbar (QAT). The QAT is a list of buttons that is always visible regardless of which tab is showing on the Ribbon.