ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Paste values ID (https://www.excelbanter.com/excel-discussion-misc-queries/1797-paste-values-id.html)

GregR

Paste values ID
 
How do I determine the ID value for "Paste Values" or for that matter how do
I determine the ID value for any built in command. TIA

Greg



Ron de Bruin

Hi Greg

Sub Test_Cell_Menu()
' Add Paste Values to the menu
Application.CommandBars("cell").Controls. _
Add Type:=msoControlButton, ID:=370, befo=1
End Sub



See
http://www.rondebruin.com/menuid.htm



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


"GregR" wrote in message ...
How do I determine the ID value for "Paste Values" or for that matter how do
I determine the ID value for any built in command. TIA

Greg






All times are GMT +1. The time now is 03:04 AM.

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