ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Add menu item to right-click menu (https://www.excelbanter.com/excel-programming/367289-add-menu-item-right-click-menu.html)

[email protected]

Add menu item to right-click menu
 
Hi,
I know how to add an item to the "Cell" commandbar :
i.e.
Dim MenuItem As CommandBarControl
Set MenuItem =
Application.CommandBars("Cells").Controls.Add(Type :=msoControlButton).

But how do I add an item to the shortcut menu that appears when you
right-click on an embedded chart ?

Thanks to anyone who can give me a push on this one.
Herman


Ardus Petus

Add menu item to right-click menu
 
Try:
Application.CommandBars("Plot Area").Controls.Add(Type:=msoControlButton).

HTH
--
AP

a écrit dans le message de news:
...
Hi,
I know how to add an item to the "Cell" commandbar :
i.e.
Dim MenuItem As CommandBarControl
Set MenuItem =
Application.CommandBars("Cells").Controls.Add(Type :=msoControlButton).

But how do I add an item to the shortcut menu that appears when you
right-click on an embedded chart ?

Thanks to anyone who can give me a push on this one.
Herman





All times are GMT +1. The time now is 02:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com