Opening VBE through VBA code -SOLVED

kpark91
StarLounger
Posts: 61
Joined: 29 Jul 2010, 14:52

Opening VBE through VBA code -SOLVED

Post by kpark91 »

Hello,

what's the code for opening VBE through VBA code in case the VBE is closed?

I've tried

Code: Select all

 Application.VBE.MainWindow.SetFocus
but this would only work in case the VBE is already open.

Thank you, :)
Last edited by kpark91 on 29 Jul 2010, 19:07, edited 1 time in total.
I don't have one

User avatar
HansV
Administrator
Posts: 74138
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Opening VBE through VBA code

Post by HansV »

Try

Application.VBE.MainWindow.Visible = True

And if you want to hide the VBE:

Application.VBE.MainWindow.Visible = False
Regards,
Hans

kpark91
StarLounger
Posts: 61
Joined: 29 Jul 2010, 14:52

Re: Opening VBE through VBA code

Post by kpark91 »

Never mind I got it!! :)
It was

Code: Select all

Application.VBE.MainWindow.Visible = True
Such simple code but I was having a brain fart.

Ahhh~~!! You posted your solution before mine :)

Thanks again, HansV.
I don't have one