6

The toolbars (menu bar and quick access bar) are missing in the Visual Basic Editor in Excel. What happened? I can't click anywhere to find them to enable again!

e.g. -

enter image description here full size

1 Answer 1

8

This sometimes happens if you leave the VBE open and the computer goes to sleep or hibernates. It's difficult to reproduce, but there's a simple fix -

Just close the VBE window and reopen it. I know, this is your default first troubleshooting step, but you forgot it in haste. It's OK, I won't tell anyone.

MS KB829059 talks about Outlook 2003 and 2007, but this applies across the entire Office Suite in 2003 and 2007.

9
  • I believe the first thing to check would be View ► Toolbars ► Standard. Stating "I can't click anywhere to find them" without specifying what has actually been tried is completely useless.
    – user385793
    Nov 5, 2014 at 16:08
  • 5
    @Jeeped, that might be possible if the menu bar was shown... Nov 5, 2014 at 16:23
  • @jbarker2160 - good point. I should have specified trying Alt+V, T to see if the menus commands are available but not visible.
    – user385793
    Nov 5, 2014 at 16:47
  • @Jeeped you should add that to the answer as a first-step. Nov 5, 2014 at 17:33
  • 1
    @Raystafarian Same as in the question - menu bar and quick access bar. But I think I found the solution now. I had the Tablet Mode activated in Windows 10. After I deactivated it and reopened the VBE, the menu bar and quick access bar appeared again.
    – Joe
    Mar 23, 2017 at 6:35

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .