Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
Overview
In This Chapter
Although the Ribbon has replaced menus and toolbars , Excel 2007 still offers developers the opportunity to customize the shortcut menus. Typically, right-clicking an item displays a context-sensitive shortcut menu containing relevant commands. In this chapter, I cover the following:
-
How to identify shortcut menus
-
How to customize the shortcut menus
-
How to disable shortcut menus
-
How to use events in conjunction with shortcut menus
-
How to create a completely new shortcut menu
The CommandBar object takes on a much less significant role in Excel 2007. This chapter covers the CommandBar object as it relates to customizing shortcut menus.