Toolbar/Menu Bar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help!

Both my menu bar and tool bar have disappeared in Excel. The only thing that
appears on my screen the spreadsheet and the header bar (ie Microsoft Excel -
Book 1).

I am not able add/delete rows or colums, or in fact do anything apart from
enter letters or numbers into the cells.

This is the same on both new workbooks and existing files.

Any ideas?

Thanks
 
Press ALT+F11 to open the Visual Basic editor. There, press CTRL+G to
display the Immediate window. In that window, type the following and press
Enter

Application.DisplayFullScreen = False

Then enter the following and press Enter

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

Then enter the following and press Enter:

Application.CommandBars("Worksheet Menu Bar").Reset

This should get your menu bar back. Once you get the menu bar, you can go to
the View menu and choose the toolbars you want to display.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 
Back
Top