Chapter 23: Working with Shortcut Menus

 Download CD Content

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.