ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   customized toolbar buttons macros to a group of users (https://www.excelbanter.com/excel-programming/375889-customized-toolbar-buttons-macros-group-users.html)

TBSpieth

customized toolbar buttons macros to a group of users
 
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.

fugazi48

customized toolbar buttons macros to a group of users
 
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.



All times are GMT +1. The time now is 07:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com