Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi. I have written a short macro to add items to the right-click menu, bu am having difficulty finding the right ID numbers. So far, I hav managed to add "Paste Values" and "Paste Formatting", as below: Sub AddItems() 'Paste Values Application.CommandBars("cell").Controls.Add Type:=msoControlButton ID:=370, befo=5 'Paste Formatting Application.CommandBars("cell").Controls.Add Type:=msoControlButton ID:=369, befo=5 End Sub I also want to add the following: - Paste Formulas - Paste Comments But I don't know the relevant ID numbers! Please can anyone tell m what they are? Thanks -- Cumberlan ----------------------------------------------------------------------- Cumberland's Profile: http://www.excelforum.com/member.php...fo&userid=3344 View this thread: http://www.excelforum.com/showthread.php?threadid=57171 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding items to a right click menu | Excel Programming | |||
Items Added to Right-Click Menu Only Visible From Some Sheets | Excel Programming | |||
Right-Click Menu Items -- Duplicate Entries | Excel Programming | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
Adding menu to the mouse right click pop-up menu | Excel Programming |