Menu terminology is often a bit confusing at first because many of the terms are similar. The following list presents the official Excel menu terminology that I refer to in this chapter:
♦ Command bar: An object that can function as a menu bar, a shortcut menu, or a toolbar. It is represented by the CommandBar object in the Microsoft Office Object Library.
♦ Menu bar: The row of words that appears directly below the application's title bar. Excel has two menu bars: One is displayed when a worksheet is active, and the other is displayed when a chart sheet is active or when an embedded chart is activated.
♦ Menu: A single, top-level element of a menu bar. For example, both of Excel's menu bars have a File menu.
♦ Menu item: An element that appears in the drop-down list when you select a menu. For example, the first menu item under the File menu is New. Menu items also appear in submenus and shortcut menus.
♦ Separator bar: A horizontal line that appears between two menu items. The separator bar is used to group similar menu items.
♦ Submenu: A second-level menu that is under some menus. For example, the Edit menu has a submenu called Clear.
♦ Submenu item: A menu item that appears in the list when you select a submenu. For example, the Edit ^ Clear submenu contains the following submenu items: All, Formats, Contents, and Comments.
♦ Shortcut menu: The floating list of menu items that appears when you right-click a selection or an object. The shortcut menu that appears depends on the current context.
♦ Enabled: A menu or a menu item that can be used. If a menu or a menu item isn't enabled, its text appears grayed, and it can't be used.
♦ Checked: The status of a menu item that represents an on/off or True/False state. A menu item can display a graphical box that is checked or unchecked. The View ^ Status Bar menu item is an example.
♦ Image: A small, graphical icon that appears next to some menu items. In VBA terms, the code associated with each image is known as a FacelD. See Chapter 22 for more information about the FacelD property.
♦ Shortcut key combination: A keystroke combination that serves as an alternative method to execute a menu item. The shortcut key combination is displayed at the right side of the menu item. For example, Ctrl+S is the shortcut key combination for the File ^ Save command.
Was this article helpful?