Indeed tommy, if one plays around with the following subs you will see that once the VBE window is opened (state 2 as far as I'm aware), you can exit from the VBE window, run the macro "IsVBEWindowOpen" and find that it's still open....It remains open (though certainly not visible) until after you completely QUIT (not just save) the application.
[VBA]
Sub OpenVBEwindow_ByVisible()
Application.VBE.MainWindow.Visible = True
End Sub
Sub OpenVBEwindow_ByState()
Application.VBE.MainWindow.WindowState = 2
End Sub
Sub IsVBEwindowOpen()
If Application.VBE.MainWindow.WindowState = 2
Then MsgBox "VBE window is open (State 2)"
End Sub
[/VBA]