adding shortcut menu items

[singincpa]

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

 

[Ron de Bruin]

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

 

[Tom Ogilvy]

there are no source events. built in buttons are associated with default
behavior.

If you add the built in buttons to th shortcut bar, they will perform in the
normal manner without setting an onaction property.