Excel - The Menu bar is missing

March 2017



Issue


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)

Solution


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)    
.Reset    
.Enabled = True    
End With    
Next x    
End Sub 

Related


Published by aakai1056.
This document, titled "Excel - The Menu bar is missing," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).