How to export a toolbar

I

ian

Hi
I have created a tool bar that I find very handy. I use it at home all the
time
How can I get that same tollbar to work on my Office computer
short if rebuilding the entire toolbar
Thanks
 
D

Dave Peterson

Is this a new customized toolbar that's always available when you open excel?

I'm gonna guess that it's just customization of the builtin toolbars (via
Tools|Customize):

Are you using the same version of excel in both spots?

If no, then rebuild/match them by hand. It'll be easier/safer.

But if they're the same version:
For both PCs:
Find the correct location for your *.xlb files

I like to make a minor modification (new toolbar with nothing in it).
Close excel and the search for *.xlb.
The one with the time/date last modified is the one I want to copy (and the one
I want to replace on the other PC).

Then just copy it from one and paste to the other.

But.....
Look at the size of the *.xlb file you want to keep. If it's over 25-30k, then
don't do it. Print screens to show all of the toolbar (and icons) you want.

Delete the *.xlb file. Rebuild it. (Notice the size is about 10-15k.) Use
that to copy|paste. And while you're at it, back this file up. The *.xlb file
can get corrupted. When it goes bad, weird things happen in excel (usually
opening & closing).

Every once in awhile, I'll just copy my backup into my "real" *.xlb file. Then
I don't have to worry about corrupted *.xlb files.

(If I'm going to make a real change to it, I'll copy a fresh copy in, make my
changes and create a new backup.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top