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

In this tutorial:

  1. Understanding Ribbon Extensibility
  2. Extending the Ribbon: An Example
  3. Step 1: Create a Macro-Enabled Office Document or Template
  4. Step 2: Create a Text File and Add the Custom XML Markup
  5. Step 3: Copy the Custom XML Markup File to the Document Package
  6. Step 4: Rename and Open the Document
  7. Hiding the Built-In Ribbon
  8. Creating Custom Tabs
  9. Customizing an Existing Tab
  10. Creating Custom Groups
  11. Customizing an Existing Group