Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add control to right click menu when something is on the clipboard
Hi,
I have managed to add an control to my right click menu. The problem is that when have something on my clipboard a right click gives me a different menu. Any tips on how to add an item to that menu would be appreciated. I am using the following code to add an item to the regular right click menu. Option Explicit Public RtClkMenu As CommandBarButton Sub CreateRtClkMenu() Set RtClkMenu = CommandBars("Cell").Controls.Add _ (Type:=msoControlButton, befo=5) With RtClkMenu .Caption = "Your button Title" .FaceId = 321 .OnAction = "Sub to be called" .BeginGroup = True End With End Sub I have tried: Set RtClkMenu = CommandBars("Paste Special Dropdown").Controls.Add _ (Type:=msoControlButton, befo=5) But have no idea where this is being added to, it is not added to my right click on a cell when there is something on the clipboard. Command bar 117 is called Clipboard but is listed as a toolbar and not a shortcut. Any assistance will be appreciated. Thanks. Sean |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy the value of cell into clipboard by double click | Excel Worksheet Functions | |||
how to copy on double-click the cell value to Clipboard | Excel Worksheet Functions | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
Auto-Click Save on Clipboard | Excel Programming | |||
Adding menu to the mouse right click pop-up menu | Excel Programming |