Chapter 31. Programming the Office 2010 Ribbon

In Office 2007, the Ribbon could not be customized by the user via the Office 2007 user interface. This capability has been added to Office 2010. The user can now click the File tab on the Ribbon, choose Options, then click Customize Ribbon.

VBA programmers, however, may want to customize the Ribbon programmatically (by running code rather than working directly with the Options dialog box). Perhaps your organization wants to 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, or otherwise automate management of this major part of the ...

Get Mastering VBA for Microsoft® Office 2010 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.