See
http://www.rondebruin.nl/menuid.htm
Read this part about the ID's
http://www.rondebruin.nl/menuid.htm#ID
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Cumberland" wrote in message
...
Hi.
I have written a short macro to add items to the right-click menu, but
am having difficulty finding the right ID numbers. So far, I have
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 me
what they are?
Thanks!
--
Cumberland
------------------------------------------------------------------------
Cumberland's Profile: http://www.excelforum.com/member.php...o&userid=33445
View this thread: http://www.excelforum.com/showthread...hreadid=571718