Excel - The Menu bar is missing

April 2018


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 
Published by aakai1056. Latest update on November 22, 2012 at 04:46 AM by deri58.
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 (https://ccm.net/).
Excel - A macro to create worksheets
Excel - Conditional display of data