H
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!
computer to another computer? Thanks for your help!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
The toolbar settings are in the *.xlb file.
B
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
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
D
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
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
Bernie Deitrick said: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