Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Settings
Dear Ron,
Worked like a charm. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero Value Settings | Excel Discussion (Misc queries) | |||
Get RGB settings | Excel Programming | |||
Settings | Excel Discussion (Misc queries) | |||
settings | Excel Worksheet Functions | |||
Add to Settings.txt | Excel Programming |