Excel menu bar missing
Solved
Hello,
I just downloaded an Excel sheet and since then I have no menu or toolbar on my session.
I cannot restore the toolbars because I have no access to anything (just the formula bar).
My restorations are not working and reinstalling my Office package is the same. However, there are no issues on other sessions.
Can you please tell me how to restore a lost menu bar?
Thank you in advance
I just downloaded an Excel sheet and since then I have no menu or toolbar on my session.
I cannot restore the toolbars because I have no access to anything (just the formula bar).
My restorations are not working and reinstalling my Office package is the same. However, there are no issues on other sessions.
Can you please tell me how to restore a lost menu bar?
Thank you in advance
Configuration: os: windows XP home
30 answers
-
Hi,
I had the same problem as you just yesterday and the link provided above for restoring the toolbar worked perfectly.
To access Visual, you press Alt-F11. There, you click on ThisWorkbook and copy the macro provided in the link. That is to say, the following:
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
All you need to do is run it and it works.-
-
-
-
@sergeHello, when you pressed alt-F11, VB should open. There, in the vertical window on the left, you have VBAProject. Below, you should have a directory called Microsoft Excel Objects and underneath, the ThisWorkbook icon.
-
Thank you very much, it works great.
I had posted the same question on the following forum:
loss of menu bar and toolbars in Excel
I didn't get a response, I hope you won't hold it against me, I'm sharing your brilliant method on the other forum.
Thanks again.
foysand
-