Menu ID of Shortmenu (Right click)
 

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

Menu ID of Shortmenu (Right click)
 

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


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


"Jos Vens" wrote in message
...
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

Menu ID of Shortmenu (Right click)
 

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")

--
HTH...

Jim Thomlinson


"Jos Vens" wrote:

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

Menu ID of Shortmenu (Right click)
 

Hi Jos

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Chip Pearson" wrote in message ...
The name of the right-click menu is "Cell" .


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


"Jos Vens" wrote in message ...
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

Menu ID of Shortmenu (Right click)
 

Thanks everyone!
Jos


"Jim Thomlinson" schreef in
bericht ...
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")

--
HTH...

Jim Thomlinson


"Jos Vens" wrote:

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