Copy Toolbar

[HelpMe]

Can someone tell me if there is a way to copy a toolbar I created on my
computer to another computer? Thanks for your help!

 

[Peo Sjoblom]

The toolbar settings are in the *.xlb file.

 

[Bernie Deitrick]

You can attach a toolbar to a file: open a file, right click on the
toolbar, choose "Customize" then on the toolbar tab click the "Attach"
button. Attach your toolbar, save the file, then copy the file to a
disk and take it to your other computer. Open it and your toolbar
should appear.

Note that your toolbar will become a permanent part of the second
computer's family of toolbars: closing the file won't delete it.
There are lots of code examples in Google showing how to create and
destroy commandbars when files are opened/closed.

HTH,
Bernie
MS Excel MVP

 

[David McRitchie]

along the lines mentioned by Bernie if you want to copy
the .xlb as it exists on one machine.. Is it you at both machines,
and do you want the exact same toolbar on both machines.
Are all your files in the same pathnames on both machines
that you have for your personal workbook and other excel files
that might be referenced.
Are the versions of Excel the same; otherwise, I would
create the toolbar on the other machine with the information.

You might take a look at my page
.http://www.mvps.org/dmcritchie/excel/barhopper.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

You can attach a toolbar to a file: open a file, right click on the
toolbar, choose "Customize" then on the toolbar tab click the "Attach"
button. Attach your toolbar, save the file, then copy the file to a
disk and take it to your other computer. Open it and your toolbar
should appear.

Note that your toolbar will become a permanent part of the second
computer's family of toolbars: closing the file won't delete it.
There are lots of code examples in Google showing how to create and
destroy commandbars when files are opened/closed.

HTH,
Bernie
MS Excel MVP