Opening VBE through VBA code -SOLVED

[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, :)

[HansV]

Try

Application.VBE.MainWindow.Visible = True

And if you want to hide the VBE:

Application.VBE.MainWindow.Visible = False

[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.