Menu ID of Shortmenu (Right click)

[Jos Vens]

Hi,

How can I determin the menu-id of the right-click menu. I'd like to change
the copy and paste items of it.

Thanks
Jos Vens

 

[Chip Pearson]

The name of the right-click menu is "Cell" .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

There are probably 3 menu's that you are looking for...

Cell, Row and Column

Dim cbrCellMenu As CommandBar
Dim cbrRowMenu As CommandBar
Dim cbrColumnMenu As CommandBar

Set cbrCellMenu = Application.CommandBars("Cell")
Set cbrRowMenu = Application.CommandBars("Row")
Set cbrRowMenu = Application.CommandBars("Column")

 

[Ron de Bruin]

Hi Jos

Use the ID from the controls for changing the menu
See http://www.rondebruin.com/menuid.htm

 

[Jos Vens]

Thanks everyone!
Jos

There are probably 3 menu's that you are looking for...

Cell, Row and Column

Dim cbrCellMenu As CommandBar
Dim cbrRowMenu As CommandBar
Dim cbrColumnMenu As CommandBar

Set cbrCellMenu = Application.CommandBars("Cell")
Set cbrRowMenu = Application.CommandBars("Row")
Set cbrRowMenu = Application.CommandBars("Column")