ShortcutMenus Method

Applies To

Application Object.

Description

Accessor. Returns a Menu object that represents a single shortcut menu. Read-only.

Syntax

object.ShortcutMenus(index)

object

Optional. The Application object.

index

Required. Specifies the shortcut menu, as shown in the following list.

Constant

Description

xlAxis

Chart Axis

xlButton

Button

xlChartSeries

Chart Series

xlChartTitles

Chart Titles

xlColumnHeader

Column

xlDebugCodePane

Debug Code Pane

xlDesktop

Desktop

xlDialogSheet

Dialog Sheet

xlDrawingObject

Drawing Object

xlEntireChart

Entire Chart

xlFloor

Chart Floor

xlGridline

Chart Gridline

xlImmediatePane

Immediate Pane

xlLegend

Chart Legend

xlMacrosheetCell

Macro Sheet Cell

xlModule

Module

xlPlotArea

Chart Plot Area

xlRowHeader

Row

xlTextBox

Text Box

xlTitleBar

Title Bar

xlToolbar

Toolbar

xlToolbarButton

Toolbar Button

xlWatchPane

Watch Pane

xlWorkbookTab

Workbook Tab

xlWorksheetCell

Worksheet Cell


Example

This example adds a new menu item to the worksheet cells shortcut menu.


ShortcutMenus(xlWorksheetCell).MenuItems.Add _
    Caption:="More..."

This example deletes the new menu item.


ShortcutMenus(xlWorksheetCell).MenuItems("More...").Delete