Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Transferring toolbars and macros to other machines
Hello
How do you transfer macros and toolbars from one machine to another? If I copy "personal.xls" to another machine, it'll overwrite everything there. MS Word has "Organizer" that makes this easy but Excel doesn't have that feature. Thanks in advance. |
#2
|
|||
|
|||
Well, you can rename personal to personal1, open BOTH files, then go into
the VB Editor (Alt+F11) and click and drag modules down into the other file. Make sure you hit your save diskette when you're done. The toolbar is a bit different. It's *.xlb where the * is your username. ************ Anne Troy www.OfficeArticles.com "Darrell" wrote in message news:_6U3f.24045$Io.5107@clgrps13... Hello How do you transfer macros and toolbars from one machine to another? If I copy "personal.xls" to another machine, it'll overwrite everything there. MS Word has "Organizer" that makes this easy but Excel doesn't have that feature. Thanks in advance. |
#3
|
|||
|
|||
Darrell
Macros can be in any workbook. They would travel with the workbook. Also in Personal.xls for global macros. Also could be in any add-in(s) *.xla you created. Toolbar and Menu customizations are stored in your xxxxxx.XLB file where xxxxxx is version-dependent name. Excel 97.....username.xlb Excel 2000...Excel9.clb Excel 2002...Excel10.xlb Excel 2003...Excel11.xlb Note: there may be other customizations you want to transfer at the same time. Before reading further....... Transferring your *.xlb file from 97 to 2003 will reduce the functionality of new version menu items, although most of them can be dragged onto the old menu. Read on......... NOTE: some settings are workbook-specific and would be stored with the workbook. For other global stored settings.......... Screen layout, color info, checked Add-ins and many ToolsOptions settings are stored in the Registry, not in the *.XLB file. To see some of what's stored in the Registry have a peek at this section in it, if you feel comfortable. HKEY_CURRENT_USER\Software\Microsoft\Office\XX.0\E xcel\Options XX is your version of Excel...8,9,10,11 Assuming you are aware of the precautions taken when editing the Registry and know how to restore a recent backup of same....... If not, maybe have a look here first...scroll down to "Registry editing tips" http://www.activewin.com/tips/reg/index.shtml Export all these keys(as a branch group) to a .REG file so's you can back them up. Note also: you may want to move over your *.ACL(autocorrect files) and any *.DIC files. For a more comprehensive listing see Dave Peterson's posting at http://snipurl.com/8r7x Gord Dibben Excel MVP On Fri, 14 Oct 2005 19:59:54 GMT, "Darrell" wrote: Hello How do you transfer macros and toolbars from one machine to another? If I copy "personal.xls" to another machine, it'll overwrite everything there. MS Word has "Organizer" that makes this easy but Excel doesn't have that feature. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving custom toolbars with macros to work on other computers | Excel Discussion (Misc queries) | |||
Why are my auditing and forms toolbars disabled? | Excel Discussion (Misc queries) | |||
excel 2003 - macros & buttons | New Users to Excel | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
Providing Toolbars to Workgroup | Excel Discussion (Misc queries) |