Adding macros to toolbars

[Guest]

I have created macros and assigned them to buttons on a custom toolbar. The
macros work fine, but when I save the file under another name the macros are
only linked to the new workbook. I can create the macros in the Personal
workbook, but I need them to be available to other users on their own
computers. Has anyone got a solution. Thanks.

 

[Dave Peterson]

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.

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)