transfer excel menu

[Jeni]

I'm having a different computer and need to transfer my customisations over
to it. I know how to transfer my macros & toolbars but can't work out how to
transfer my menus, can anyone help me please?

 

[Gary''s Student]

Locate a file on your computer called:

Excel10.xlb or Excel11.xlb or Excel12.xlb (depending on your version of
Excel)

and move it to the new computer.

 

[Gord Dibben]

Here is a list from Dave Peterson...............

I have a short list of things to copy/update when we change pc's at work.

It's not complete, but may help you.

Word/Excel files:

FileName Use
custom.dic personal dictionary
*.acl personal autocorrect list
mssp2_en.exc personal exclusion dictionary
normal.dot default (for new documents) template
*.dot Any other templates you've made

*.xlb personal toolbar
book.xlt defaults for new workbooks
sheet.xlt defaults for new worksheets
personal.xl* personal macros
*.xlt Any other templates you've made

And don't forget any:
Local files (If you don’t store on LAN)
(Settings) Directories and other defaults (Tools|Options stuff)

End Dave............................

Note: Excel also stores a lot of settings in the registry. Most at

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options


Gord Dibben MS Excel MVP