bump!!!

I tried to add a button for a macro while recording the actions. I can
easily add the button, but it won't record the macro assigned to it.

Application.CommandBars("Formatting").Controls.Add
Type:=msoControlButton, _
ID:=2950, Befo=2121

This adds a smiley face button to the toolbar. I don't know how to change
the assigned macro to that button with programming.
"TBSpieth" wrote:

I have several simple customized toolbar buttons that copy the button image
to an excel spreadsheet. How can I easily distribute these tool bar buttons
with the assocated macro to a group of about 15 users? Thanks for the help.