ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Toolbars and menu items have gone (https://www.excelbanter.com/excel-programming/290745-re-toolbars-menu-items-have-gone.html)

Ron de Bruin

Toolbars and menu items have gone
 
Hi Jonathan

Try to rename your .xlb file

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

Close Excel
Do a search for .xlb in windows
Rename the file you find (mine is named Excel10.xlb in 2002)
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
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Jonathan" <jonathan(-put-an-AT-thingy-here-)josco.demon.co.uk wrote in message
...
Please can someone help a poor fool who has messed with VBA and has consequently lost all Excel toolbars and menu items. I

can view nothing but a grid! I tried re-installing office but to no avail. "A little knowledge is a dangerous thing!"




All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com