tool bar in excel

[a_d66]

hi,
how do I copy a private tool bar to another computer??
thanks

 

[Ron de Bruin]

Hi

If you mean all your toolbar settings?
Try this

The .xlb file has all Toolbar customization in it.

Do a search for .xlb in windows
Copy the file you found (mine is named Excel10.xlb in 2002)
to the other computer.
first Rename the .xlb that is on that computer

You can also attach your toolbar to a file and save it with the file
See the Excel help for this

 

[a_d66]

thanks
1. I ment a private tool bar
2. how do I attache a tool bar?

 

[Ron de Bruin]

Did you look in the help???

Try this

You can attach a toolbar to an excel workbook.
Tools|customize|Toolbars Tab|Attach button.

Jan Karel Pieterse has posted some nice instructions for attached toolbars:
http://google.com/[email protected]

 

[a_d66]

I dont have an attach bottom when i get to the tollbar tab.
i use the office xp.

 

[a_d66]

I dont have an attach bottom when i get to the tollbar tab.
i use the office xp.

 

[Ron de Bruin]

Look again
Tools|customize|Toolbars Tab|Attach button.

Below the reset button on the right

 

[a_d66]

hey,
there is no "save as" below the "reset".
do you know what is "add-in"? i tried to save the file as add-in and
when i open the file it was blank.
thanks

 

[Dave Peterson]

When I use Tools|Customize and click on the Toolbars tab, I see these buttons on
the right hand side:

New...
Rename... (greyed out)
Delete (greyed out)
Reset
Attach...

If you don't see them, what version of excel are you using?

 

[a_d66]

Ron and Dave,
thank you very much!!
I did it!!! you were very helpful!!!!
have a good day!