Lost my "Menu Bar"

M

Michael

The one that shows "File" "Edit" "Tools" etc...

I must have hit a strange button, but it's gone and nobody
in the office knows how to bring it back.

Thanks
 
R

Ron de Bruin

Run this macro Michael

Sub test()
Application.CommandBars(1).Enabled = True
End Sub
 
A

ameysun

================================================
MS Excel Menubar is missing / not displayed.
================================================

Solution:
----------
Not so sure, but you can try this.
You need to delete Excel's toolbar file, and generate a new one.
Before deleting *.xlb file, please take a backup of the same file.

Steps:
----------

1) Please ensure that Excel is closed

2) Delete the physical file from your PC

if you are using Win 98
delete file = "$winsys\Application Data\Microsoft\Excel\excel*.xlb"

if you are using Win 98/NT/Me
delete file = "$winsys\Profiles\" & usrname & "\Applicatio
Data\Microsoft\Excel\excel*.xlb"

if you are using Win 2k/ Xp
delete file = "c:\Documents and Settings\" & usrname & "\Applicatio
Data\Microsoft\Excel\excel*.xlb"

3) After "xlb-file is deleted", restart the application i.e. MS Excel

* You should see Excel Menubar back in place
 
Top