Chapter 22: Working with the Ribbon

 Download CD Content

Overview

In This Chapter

Perhaps the most significant change in Office 2007 is the new Ribbon-based user interface. This chapter provides an overview of the Ribbon and describes how it relates to VBA.

• The new Excel 2007 Ribbon UI, from a user's perspective

• How you can use VBA to work with the Ribbon

• An introduction to customizing the Ribbon with RibbonX code

• Examples of workbooks that modify the Ribbon

• Boiler-plate code for creating an old-style toolbar

The Ribbon is a brand new concept in user interface design. You use XML to modify the Ribbon, but there are a few Ribbon- related operations that you can perform with VBA.