Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Toolbars
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.xlb 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 Thu, 8 Dec 2005 15:21:02 -0800, "A Pragmatic Cynic" <A Pragmatic wrote: My office IT folks just told us they will be changing out our desktop PCs in the next few weeks. Over the last 3 years I have spent a lot of time in Excel so I built custom menus and macros I would hate to lose. How can I save these and load them on my new machine when it arrives instead of starting over? I have also modified the default start-up with excel (e.g., brings in a custom color pallete). Can that be saved? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Toolbars
Thank you. Fortunately, no version conversion at this point. Just the
desktop box. The macros I want to move are global. "Gord Dibben" wrote: 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.xlb 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 Thu, 8 Dec 2005 15:21:02 -0800, "A Pragmatic Cynic" <A Pragmatic wrote: My office IT folks just told us they will be changing out our desktop PCs in the next few weeks. Over the last 3 years I have spent a lot of time in Excel so I built custom menus and macros I would hate to lose. How can I save these and load them on my new machine when it arrives instead of starting over? I have also modified the default start-up with excel (e.g., brings in a custom color pallete). Can that be saved? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Toolbars
Hi Cynic,
With no change of Excel version you should actually be able to reuse your toolbars .xlb file (carefully). It would be nice if you have both machines for awhile but have no idea if you will have that option. In any case no matter what you do the things you have to do are the same as making backups that you can recover files from or start over on a new machine after a disaster.. http://www.mvps.org/dmcritchie/excel/backup.htm and I would suggest also looking over http://www.mvps.org/dmcritchie/excel/toolbars.htm and documenting your toolbar usage with Print Screen to usually Ctrl+Print Screen and pasting to a Word document and print that. And running the macro for documentation of you menus at http://www.mvps.org/dmcritchie/excel/barhopper.htm HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
all toolbars and shortcut bar is missing (can't see it) in excel | Excel Discussion (Misc queries) | |||
In excel 2003, the menu bar and all toolbars disappear | Excel Discussion (Misc queries) |