View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Menu-bar missing when launching Excel

Hi tbd

This info is in your xlb file

You can rename or delete it to restore your menus

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 to your system
Excel will create a new file 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/tips.htm




"tbd" wrote in message ...
Greetings,
I used VBA to remove menu and tool bars from the first sheet of an
.xls I'm developing, but managed to change Excel's defaults such that when
simply launching excel, the menu-bar is missing!

Does Excel use a configuration text-file I can change with notepad?

Note: I can open Help via the code-page (right-click on 'sheet1'
view code) but can't change worksheet properties there. I can get to
worrksheet menu-bar by opening my VBA code, it runs code to show menus,
though, my attempts to reset default properties have failed.

Thanks/Cheers!