O'Reilly logo

Mastering VBA for Microsoft® Office 2010 by Richard Mansfield

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required