close

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

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.

--Elainequot;lhcookquot; wrote:

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

Thank you Elaine. I haven't tried this yet but looks good. I'll let you know.
Lewquot;Elainequot; wrote:

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()