PC Review


Reply
Thread Tools Rate Thread

customized toolbar buttons macros to a group of users

 
 
=?Utf-8?B?VEJTcGlldGg=?=
Guest
Posts: n/a
 
      24th Oct 2006
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 With Quote
 
 
 
 
=?Utf-8?B?ZnVnYXppNDg=?=
Guest
Posts: n/a
 
      30th Oct 2006
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.
"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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you launch Macros from a customized Toolbar? Fan924 Microsoft Excel Programming 3 7th Dec 2008 06:16 AM
Customized Toolbar Macro Buttons MSThinksItKnowsBetter Microsoft Excel Setup 7 1st Jun 2008 09:28 AM
Make a toolbar with customized buttons jobeer Microsoft Excel Programming 1 16th Mar 2006 05:25 PM
I Can't Save my Customized Toolbar Buttons (Word 2003) J. Danniel Microsoft Word New Users 2 8th Sep 2005 11:52 PM
Customized toolbar buttons =?Utf-8?B?QnJhZEB6ZWxsZQ==?= Microsoft Word Document Management 1 14th May 2004 10:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:12 AM.