Excel - The Menu bar is missing

December 2016


I just downloaded a worksheet and opened it with Excel. Since then, the Menu bar of Excel has disappeared. I can't restore the bars since I no longer have access to anything (just the Formula bar)


Press Alt-F11 select > ThisWorkbook and you copy/paste this macro:
Sub ResetCommandBars()    
Dim x    
On Error Resume Next    
For x = 1 To Application.CommandBars.Count    
With Application.CommandBars(x)    
.Enabled = True    
End With    
Next x    
End Sub 

Related :

This document entitled « Excel - The Menu bar is missing » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.