Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Trying to customize my menubar, I managed to removed the file category. I
have been unable to restore it although I have tried numerous options, including: Tools, customize, options, reset, as well as Tools, customize, toolbars, reset. Does anyone know how I can restore my original menubar settings? Tx. |
#2
![]() |
|||
|
|||
![]()
Hi
Try this then if you try to reset in manual 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 3. Rename the file you find (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 "isabella9" wrote in message ... Trying to customize my menubar, I managed to removed the file category. I have been unable to restore it although I have tried numerous options, including: Tools, customize, options, reset, as well as Tools, customize, toolbars, reset. Does anyone know how I can restore my original menubar settings? Tx. |
#3
![]() |
|||
|
|||
![]()
Ron, you're a genius!!!! None of the tech folks at my job could figure this
out! THANK YOU! Miriam "Ron de Bruin" wrote: Hi Try this then if you try to reset in manual 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 3. Rename the file you find (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 "isabella9" wrote in message ... Trying to customize my menubar, I managed to removed the file category. I have been unable to restore it although I have tried numerous options, including: Tools, customize, options, reset, as well as Tools, customize, toolbars, reset. Does anyone know how I can restore my original menubar settings? Tx. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text in Excel is lost | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |