Buttons in a toolbar

[Daddio_1962]

How do I make a button I added to an Excel toolbar work for other users who
are opening the file?

 

[FSt1]

hi,
toolbar button are unique to the machine. they don't follow the file.
i might suggest that you put a command button on the sheet. command buttons
follow the file.

Regards
FSt1

 

[FSt1]

hi
Afterthought....
you could copy the button and paste it in a xl file then put it on the other
machines.
but i would still recomend the command button on the sheet.

Regards
FSt1

 

[Gord Dibben]

If you create a new Toolbar with your button on it, you can attach that Toolbar
to the file.

Tools>Customize>Toolbars>New.

Give it a name like MyBar

Add a smileyface button from Macros under Commands.

Right-click on that button and assign your macro.

Make any changes you want to the button name or button face.

When happy, Toolbars>Attach.

Select and "Copy>>"

Save Workbook.


Gord Dibben MS Excel MVP

 

[Chip Pearson]

toolbar button are unique to the machine. they don't follow the file.

They do if you Attach the toolbar to the workbook.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Dave Peterson]

If you're executing a macro that you created, I think your life will be lots
easier if you create that toolbar when the workbook opens and destroy it when
the workbook closes.

Some references if you want to look at that option:

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

In xl2007, those toolbars and menu modifications will show up under the addins.

 

[FSt1]

hi
i just learned somthing. how do you attach it to the file?

regards
FSt1

 

[Dave Peterson]

Start here:
http://www.jkp-ads.com/Articles/DistributeMacro04.htm
Jan Karel Pieterse's site

(but you may want to consider creating that toolbar in code)

 

[Gord Dibben]

Read my post.

Gord

hi
i just learned somthing. how do you attach it to the file?

regards
FSt1