Adding Button to Tool Bar

[Guest]

I want to add a button to my tool bar to run a little macro I have written. I
want this button to be available every time I open excel. How do I do this?
Also, how can I send the button and functionality to a coworker so that she
can have it on her computer everytime she opens excel.
Any help would be greatly appreciated!

 

[Guest]

That's Awesome. How do I send this button to my coworker?

 

[Dave Peterson]

John Walkenbach's menumaker adds menu items on the fly. It's really simple to
use. You can find it:
http://j-walk.com/ss/excel/tips/tip53.htm

If you want a toolbar, here's how I do it:
http://groups.google.co.uk/[email protected]

It's not quite as pretty as John's, but I try to keep the number of items on a
toolbar less than a dozen or so. (I find the menus much nicer.)

 

[Guest]

Glad you like it!

Post back with version info on both Excel/Office and Windows OS.|:>)

 

[Guest]

OS- Windows XP
Excel 2003

John Walkenbach's menumaker adds menu items on the fly. It's really simple to
use. You can find it:
http://j-walk.com/ss/excel/tips/tip53.htm

If you want a toolbar, here's how I do it:
http://groups.google.co.uk/[email protected]

It's not quite as pretty as John's, but I try to keep the number of items on a
toolbar less than a dozen or so. (I find the menus much nicer.)

 

[Dave Peterson]

I use each of them with the same version of windows and excel. They work ok for
me.