Shortcut Menus

Cell, Row and Column

There are actually 2 of these shortcut menus in Excel
The first is used when the worksheet is in Normal view.
The second is used when the worksheet in in Page Break Preview.

Define a shortcut key

To work with the shortcut menus you need to know the corresponding Caption and Index values
The index values for the shortcut menus have not remained consistent between versions

You should always refer to the Caption for reference

to disable all of the right-click shortcut menus

To disable all of the shortcut menus using the mouse use commandbars("ToolBar List").Enabled = False

It is possible to create an entirely new shortcut menu

Deleting a shortcut menu

Restoring a shortcut menu

Deleting a menu on a shortcut menu

Restoring a menu on a shortcut menu

Deleting a submenu on a shortcut menu

Restores a submenu on a shortcut menu

The Reset method is used to populate the Formulas submenu.