Chapter 31Programming the Office 2016 Ribbon
VBA programmers may want to customize the Office applications' Ribbons programmatically (via macro code as opposed to the user manually manipulating the Options dialog box). Perhaps your organization wants to perform tasks like these:
- Hide certain features in Excel
- Add a step-through wizard to Word
- Create a Ribbon that is custom-designed for working with a particular presentation
- Add a special tab containing capabilities relevant to your business
- Otherwise automate management of this major part of the user interface.
Or, you might want to create dynamic Ribbon effects, such as hiding, disabling, revealing, or modifying Ribbon elements—labels, groups, controls, or whatever—based on the user's behaviors ...
Get Mastering VBA for Microsoft Office 2016 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
