0
Thanks

A few words of thanks would be greatly appreciated.

Excel - The Menu bar is missing



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 
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Related

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).

0 Comments