Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default All Excel Menus have disappeared

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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default All Excel Menus have disappeared

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)





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"BethB" wrote in message ...
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!

  #3   Report Post  
Member
 
Location: Sweden
Posts: 30
Default

Try following VBA code for enabling menu bar

Code:
Application.CommandBars.ActiveMenuBar.Enabled = True
Now stop the macro; from menubar, select toolscustomize;
From the dialog box in toolbars tab, put check marks on
- standard
- formatting
- task pen




Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
difference between word 2003 menus and word 2007 menus-Explain pl kali Excel Discussion (Misc queries) 1 August 29th 07 07:56 AM
All menus disappeared even the File Edit [email protected] Excel Discussion (Misc queries) 2 August 30th 06 01:27 PM
Excel has disappeared David Excel Discussion (Misc queries) 2 January 9th 06 06:49 PM
New Menus - attaching but menus are reset Greegan Excel Worksheet Functions 0 November 5th 05 03:19 PM
Excel disappeared Evan Moore Excel Discussion (Misc queries) 2 May 18th 05 11:58 PM


All times are GMT +1. The time now is 10:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"