Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Customized Toolbar Macro Buttons MSThinksItKnowsBetter Setting up and Configuration of Excel 8 June 1st 08 09:28 AM
Make a toolbar with customized buttons jobeer[_2_] Excel Programming 1 March 16th 06 05:25 PM
Group buttons from the forms toolbar GregR Excel Discussion (Misc queries) 1 December 7th 04 01:25 AM
Toolbar Buttons and Macros available always Jerry[_14_] Excel Programming 3 August 20th 04 09:06 PM
Names of macros for toolbar buttons DredanZyl[_3_] Excel Programming 3 June 6th 04 10:17 AM


All times are GMT +1. The time now is 01:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"