Menu bar still Missing

  • Thread starter Thread starter Ian McIntosh
  • Start date Start date
I

Ian McIntosh

I have tried the solution recommended below but the menu
bar is still not visible. If you read this Norman do you
have any other suggestions? TIA

Ian
==========================================================
Hi Ian!

With a workbook open, use ALT+F11 [Gets you to the Visual
Basic
Editor (VBE)]

View > Immediate window

Copy/paste or type the code line below into the Immediate
window and
then press ENTER

Application.CommandBars("Worksheet Menu Bar").Enabled =
True

To get back to Excel press Alt+Q

Hope that you will now breathe a sigh of relief.
 
Hi Ian

Try this then

Often this is a corrupt or bloated toolbar 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 (my file 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)
 
Back
Top