Creating a customized ribbon
This recipe is optional, though very useful.
There are several ways that you can invoke a macro. After activating the Developer ribbon, it is relatively easy to click on the Developer tab, and then to choose the Macros button in the Code group. But what if you don't want to do it that way? Shortcuts may help, but only up to a point because macros have a way of proliferating quickly.
This recipe will show you how to create a new ribbon, group, and icons.
Getting ready
Open Excel, with a new sheet active.
How to do it…
- Before starting with customization, there is an important yet simple way to manipulate the ribbon in Excel. This is not really a customization, but it is still important to know how to control the interface. If you double-click any of the tabs on the ribbon, the ribbon will collapse. By double-clicking the tab again, the ribbon will expand, showing the standard, full view:
Figure 1.26 – The Developer...
