Settings
 

OK, I've really messed up my toolbars, to the point that when I
right-click in an empty space in the menu bar to make other menu bars
visible, the drop down only shows options for "Standard" and
"Formatting". I have another computer where all the toolbars are
correct, so I was wondering if there's a file that contains all the
settings, etc. that I can copy from one machine to another? If not,
how can I restore everything? Thank you.

Settings
 

Hi CR

Standard reply :

Maybe you have a corrupt or bloated xlb file *normal* size is < 30 kb.
The .xlb file has all Toolbar customization in it.

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and folders)
3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm on your system
Excel will create a new one for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it)


--
Regards Ron de Bruin
http://www.rondebruin.nl



"CR" wrote in message oups.com...
OK, I've really messed up my toolbars, to the point that when I
right-click in an empty space in the menu bar to make other menu bars
visible, the drop down only shows options for "Standard" and
"Formatting". I have another computer where all the toolbars are
correct, so I was wondering if there's a file that contains all the
settings, etc. that I can copy from one machine to another? If not,
how can I restore everything? Thank you.

Settings
 

Dear Ron,

Worked like a charm. Thank you!