Backing up Custom toolbars and macro buttons

[Guest]

Morning All,

I have to backup my works pc and have lots of custom toolbars in Excel, and
macro's linked to the toolbar buttons.

What files do I need to backup to retrain this for my new pc? Im using
office 97, new machine still has office 97.

I believe the macros are in personal.xla? Not totally sure but what other
files should I save?

Many Thanks

 

[Nikos Yannacopoulos]

Adam,

Personal.xls holds your (global) macros. Toolbars are stored in a file
called Excel.xlb. This file would normally be stored in:

C:\Documents and Settings\YourUserName\Application Data\Microsoft\Excel

if you have Windows 2K or XP, or

C:\Program Files\Microsoft Office\Office\XLStart

if you have an earlier version of Windows. If you can't find it in either of
those folders, do a serch.

HTH,
Nikos

 

[Gord Dibben]

Adam

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 Tools>Options
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\Excel\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