Questions About Ribbon Customization
Can the customizations apply only to a certain workbook?
No. The Customize the Ribbon command in Excel 2016 applies to all workbooks.
Can I reset my customizations and go back to the original ribbon?
Right-click the ribbon and select Customize the Ribbon. Below the right list box, select Reset, Reset All Customizations.
How can I get complete control over the ribbon?
Learn RibbonX and write some VBA to build your own ribbon.
- For more information on building your own ribbon, see RibbonX: Customizing the Office 2007 Ribbon, by Robert Martin, Ken Puls, and Teresa Hennig (Wiley, ISBN 0470191112).
These ribbon customizations are really lacking. Is there another option that doesn’t require me to write a program?
Yes, a number of third-party ribbon customization programs are available. For example, check out a free one from Excel MVP Andy Pope at www.andypope.info/vba/ribboneditor.htm.