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
- Nov 03 Mon 2008 20:47
How do I take a toolbar created at home and install it at work?
close
全站熱搜
留言列表
發表留言