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

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

"gwen" wrote:

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

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,

"Bob Umlas, Excel MVP" wrote:

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

"gwen" wrote:

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

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 wrote:

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,

"Bob Umlas, Excel MVP" wrote:

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

"gwen" wrote:

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

--

Dave Peterson

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.

"Dave Peterson" wrote:

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 wrote:

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,

"Bob Umlas, Excel MVP" wrote:

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

"gwen" wrote:

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

--

Dave Peterson

Thanks, it worked perfectly.

Gwen

"Bob Umlas, Excel MVP" wrote:

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

"gwen" wrote:

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