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
Configuration: os: windows XP home

30 answers

  • Votes
  • Date
  • Descending date
  1. 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.
    1. Thank you very much for the solution.
      I racked my brains over it for hours and it works. I don't know how but it's effective!

      Well done and thanks again.
    2. Thank you so much for the code - it helped me a lot - since I spent hours looking for the solution - thank you very much
    3. Apparently, I have the same problem as the others.
      After opening a file where I had to change the macro security level to use it, the menu bar has disappeared. I can't find ThisWorkbook in Visual Basic to apply your instructions.
      Can you help me a bit more?
      Thanks
    4. @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.
    5. 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