Visual Basic Editor--Where did the menu bar go?? 1

[clhare]

Help!!

I just opened up the Visual Basic Editor in Word to work on a macro and find the menu bar and toolbars are not there. How do I get them back?

Any help is greatly appreciated!

Cheryl

 

[TonyJollans]

Hi Cheryl,

I have seen this on occasion and never found out a cause. If you close Word (and possibly Outlook if it's using Word as its editor) and all VBE sessions in other Office apps and then restart Word and go back to the VBE, I have always found it returns to normal.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[combo]

Hi,
Execute the following code:

Application.VBE.CommandBars(1).Enabled = True

combo

 

[TonyJollans]

Hi combo,

On the occasions I have seen this (always in 2000 I think), all the toolbars and the menu have gone - leaving only the title bar and the window(s), and nothing I have tried has brought them back - it's like the VBE thinks they're there but they're just not actually displayed on the screen. As I said I have always found everything back to normal after restarting the app.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[clhare]

Thank you Tony! That did the trick!

Any help is greatly appreciated!

Cheryl

 

[combo]

Hi Tony,
I've just tested it in xp. After
Application.VBE.CommandBars(1).Enabled=False
VBE menubar hides and is not visible in the available commandbars when customising. After closing (excel) and re-opening, the menu is still not available. This remains for VBE opened from word etc.
As VBE window is available throughout office applications, guess that with more office applications openeded it can behave as many instances of VBE application. The last instance closed saves its settings.
There may be some tricks there:
- when closing VBE window, it still remains, but becomes hidden.
- if you use word as an editor in outlook, I think it can keep VBE instance hidden and menubar changes will not be saved

combo

 

[TonyJollans]

Hi combo,

I agree with everything you say but this problem is something different (Office 2K under WIn XP in my case) - some kind of corruption seems to get to the running VBE app. Switch to another app, come back later to the VBE and the toolbars are all gone - still enabled, still 'visible', but just not there. For me, restarting has always cured it - till the next time. I'm now running 2K3 and don't recall seeing it for a while.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[combo]

Hi Tony,
I agree with you that this can be a corruption in VBE/windows settings. I sometimes use WinSpy++ by Catch22. As I mentioned, after closing VBE window, it becomes only hidden. I can make it visible and functional with this tool, but it appears without any toolbar. This may be similar case.

combo