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

Raystafarian
  • 21,963
  • 12
  • 64
  • 91

1 Answers1

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.

Raystafarian
  • 21,963
  • 12
  • 64
  • 91