Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
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.