You can add it like this and you don't need the onaction code

..Controls.Add Type:=msoControlButton, ID:=4

See this page for the ID numbers (see also the linls at the bottom of the page)
http://www.rondebruin.com/menuid.htm

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


"singincpa" wrote in message ...

I am trying to add some existing Excel commands to my shortcut bars (eg
Sort, Find & Replace, etc.), but I don't know what the OnAction needs
to be for each of them. Is there a way to get a list of all of the
source events from Excel? Obviously I am not a macro or VBA expert.


--
singincpa
------------------------------------------------------------------------
singincpa's Profile: http://www.excelforum.com/member.php...o&userid=15874
View this thread: http://www.excelforum.com/showthread...hreadid=273612