All Excel Menus have disappeared

[BethB]

Hi,
For some reason all of the menus in excel have disappeared. I have closed
and re-opened the program several times along with following the directions
of the previous posts with similar problems. When I right click on the top
of the screen, I only get options to minimize or maximize the screen, no
options for toolbars etc. I even tried changing the resolution and running
VB scripts. I'm working with 2003 and have had no luck yet.

Thanks!

 

[Ron de Bruin]

Hi Beth

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 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)

 

[Chris Bode]

Try following VBA code for enabling menu bar


Code
-------------------

Application.CommandBars.ActiveMenuBar.Enabled = True

-------------------


Now stop the macro; from menubar, select tools>customize;
From the dialog box in toolbars tab, put check marks on
- standard
- formatting
- task pen




Chris