Importing custom toolbar

[2D Rick]

I created 6 macros in the personal.xls and then created a custom
toolbar.
I placed 6 buttons on the toolbar and assigned a macro to each one.

I moved the personal.xls to another PC where the macros work fine.
How do I get the custom toolbar onto the new PC?

Thanks for any help you can provide,
Rick

 

[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)

 

[Guest]

Did you try copying the workbook with the toolbar. Then you can open it with
the same instance of Excel as the new file, and I think you will be able to
copy it by activating the workbook that needs the toolbar, then
Tools/Customize/Toolbars/click the toolbar, then click Attach