copying custom tool bar

[gwen]

Is there a way to copy the custom tool bar I am using on my computer to the
LAN so that it can be loaded onto another's computer and into their Excel
startpage?

Thanks,

Gwen

 

[Bob Umlas, Excel MVP]

It depends on how the toolbar was created. You can use
view/toolbars/customize, click the Attach button, and attach the toolbar to
the workbook, then when the workbook opens, so does the toolbar, wherever it
is stored. If it's built using VBA code, then that code must be run on the LAN
HTH

 

[John]

This does not work on Excel 2003. The toolbar was built manually. When i
click attach and copy the custom toolbar to the right hand pane of the
window, i then click OK then close the next window. The toolbar does not
appear in the new workbook i created until i add it as i would add any
toolbar.
Saving the file, closing and copying to another computer does not bring the
toolbar.
Copying the file in which the toolbar was originally created to another
computer does not bring the toolbar either, even after the same 'attach'
process.
What am i doing wrong?
Thanks,

 

[Dave Peterson]

I'd start by reading Jan Karel Pieterse's web page:
http://www.jkp-ads.com/Articles/DistributeMacro04.htm

Especially the paragraph that starts with:

"Excel checks the user's .xlb file to see whether the toolbar is already on the
system."

 

[John]

Thank you for your comment and link to the site, which has helpful and
extremely well written information. I have since determined empirically that
a toolbar can be attached to an Excel 5.0/95 file and carried to Excel 2003
on another PC, however
when attached to a file in Excel 2003 then saved as type 2003 & 5.0/95 it is
not retained. If saved as Excel 2003 vs 2003 & 5.0/95 the toolbar is not
loaded on a system running Excel 5.0/95 or Excel 7.0/95. That's what i
wanted to do, and i can't.
Thanks again.

 

[gwen]

Thanks, it worked perfectly.

Gwen

It depends on how the toolbar was created. You can use
view/toolbars/customize, click the Attach button, and attach the toolbar to
the workbook, then when the workbook opens, so does the toolbar, wherever it
is stored. If it's built using VBA code, then that code must be run on the LAN
HTH