Home / MS-Excel / General Formatting

Customizing the Office 2007 Ribbon

This tutorial presents some techniques for making your macros more accessible. Learn how to enable your users to use familiar tools-namely, the Office 2007 Ribbon and its tabs, groups, and various buttons to run your macros.

Following these sections:

  • Understanding Ribbon Extensibility

  • Extending the Ribbon: An Example

  • Step 1: Create a Macro-Enabled Office Document or Template

  • Step 2: Create a Text File and Add the Custom XML Markup

  • Step 3: Copy the Custom XML Markup File to the Document Package

  • Step 4: Rename and Open the Document

  • Hiding the Built-In Ribbon

  • Creating Custom Tabs

  • Customizing an Existing Tab

  • Creating Custom Groups and Customizing an Existing Group