How do I take a toolbar created at home and install it at work?

[lhcook]

I have created some custom Excel toolbars at home. How can I copy those
toolbars so I can install them on my computer at work?
Thanks,
Lewis Cook

[Elaine]

This is the way that I would do it.

At Home:
1. Open Excel and right click the toolbar you want to take to the office
2. Select Customize and the Toolbars tab
3. Click Attach and copy the custom toolbars to the Toolbars in Workbook side
4. Save file (say ToolbarPics.xls
5. If any of the custom buttons are attached to code, copy code to a text
file (Cde.txt)
6. Mail ToolbarPics.xls and Code.txt to your work email address

At Work:
1. Open attachment
2. If you have code, copy code to your personal worksheet or the appropriate
place

Once you have done this, the toolbars will be available to you, regardless
of the worksheet that you open. Please try this and let me know if this works.

--Elaine


"lhcook" wrote:

> I have created some custom Excel toolbars at home. How can I copy those
> toolbars so I can install them on my computer at work?
> Thanks,
> Lewis Cook

[lhcook]

Thank you Elaine. I haven't tried this yet but looks good. I'll let you know.
Lew


"Elaine" wrote:

> This is the way that I would do it.
>
> At Home:
> 1. Open Excel and right click the toolbar you want to take to the office
> 2. Select Customize and the Toolbars tab
> 3. Click Attach and copy the custom toolbars to the Toolbars in Workbook side
> 4. Save file (say ToolbarPics.xls
> 5. If any of the custom buttons are attached to code, copy code to a text
> file (Cde.txt)
> 6. Mail ToolbarPics.xls and Code.txt to your work email address
>
> At Work:
> 1. Open attachment
> 2. If you have code, copy code to your personal worksheet or the appropriate
> place
>
> Once you have done this, the toolbars will be available to you, regardless
> of the worksheet that you open. Please try this and let me know if this works.
>
> --Elaine
>
>
> "lhcook" wrote:
>
> > I have created some custom Excel toolbars at home. How can I copy those
> > toolbars so I can install them on my computer at work?
> > Thanks,
> > Lewis Cook