How to customize the Office 2007 Ribbon

How to customize the Office 2007 Ribbon

One of the biggest UI changes in Office 2007 is the ribbon. This UI element displays the most frequently used commands in a strip across the top of the screen. It is meant to replace the Office suite's ever-growing list of drop-down menus, toolbars and task panes, many of which sit unutilized by end users.

The ribbon does share a similarity with the menu list, though -- it can be customized. The best tool for the job is Visual Studio 2005 Tools for Office,  which was just released in beta for development for Office 2007. However, a combination of XML markup and any .NET language (including VB 6 and VBA) will suffice.

A two-part tutorial recently posted on MSDN, Customizing the Office (2007) Ribbon User Interface for Developers by Frank Rice, examines the many types of customization that are possible, offers hints and code samples and addresses frequently asked questions about Office 2007 development.

In Part 1, Rice offers a quick guide to the three ways to create custom, application-level Ribbon UI elements for Word, Excel and PowerPoint in Office 2007 -- COM add-ins, application-specific add-ins and Word 2007 templates. Rice then covers customization for Access 2007, which is a bit different because cannot add parts to the database file, and several

    Requires Free Membership to View

    Login

    When you register, you'll begin receiving targeted emails from my team of award-winning writers. Our goal is to provide a unique online resource for developers, architects and development managers tasked with building and maintaining enterprise applications using Visual Basic, C# and the Microsoft .NET platform.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchWinDevelopment.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchWinDevelopment.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

additional customization scenarios.

Part 2 stands as an appendix of sorts. It presents descriptions, attributes and child information for Ribbon controls, lists callbacks and signatures for VB.NET, VBA, C++ and C, and includes an FAQ section. Between the samples provided in Part 1 and the resources in Part 2, Rice concludes, developers should be ready to start customizing Office 2007 for their end users.

For other Office 2007 development resources, check out David Gristwood's blog entry,  So Many Office 2007 Resources for Developers Out There.

More on Office development from SearchVB.com

 

This was first published in September 2006

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

Back to top