button ID for Paste Values (NL/XL/2003)

Topic

New Reply

Hello,

I like to re-create the button ‘Paste Values’ from the ‘Edit menu’ on a new commandbar
I want to do it bij VBA, but I’m not able find to correct ID number.
This functions is normaly not shown in the menu, but when altering the commandbars in Excel it is selectable from the Commands tab

Thanks in advance for your answer.

Patrick Schouten
The Netherlands

Reply | Quote

Replies

If you add the button manually, you can find the ID by typing the following in the Immediate window then pressing Enter:

? CommandBars(“Standard”).Controls(“Paste Values”).ID

I get 370. You can then remove the button and write your code to add it.

Reply | Quote

Yes, this will do the trick
Thanks again

Reply | Quote

That of course does not work on a different language of Excel.
Download my xlmenufundict to get a listing of all commandbar Id’s of the various Office apps.

Reply | Quote

I’m aware of that, of course, but the developer could find the ID using the local language, then use the language-independent ID from then on.

But your XLMenuFuncDict workbook is very handy – I use it frequently.

Reply | Quote