Kipp

NOTE: some settings are workbook-specific and would be stored with the
workbook.  

For other global stored settings..........

Do a file search for *.XLB which is the file that Excel stores some
preferences in(some are written to the registry, see below).

Menu and Toolbar customizations are saved in the *.XLB file.

A file search may turn up more than one *.XLB file.  You will have
to determine which is correct one.

Note where they are and make a minor change to a Toolbar in Excel.
Save/close and see which *.XLB file was modified.

You can copy this file and save as a backup

If changing versions of Excel at the same time, you will find that
the *.XLB names are different.  Make the appropriate name changes
and place in the proper folder.

xl97 is username8.xlb
xl2000 is excel.xlb.
xl2002 is excel10.xlb

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