customized toolbar buttons macros to a group of users

T

TBSpieth

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.
 
F

fugazi48

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, Before:=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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top