Closing Visual Basic Editor 1

[lmontes]

How can I close the VBE using VBA

 

[VBslammer]

Set a reference to the "Microsoft Visual Basic for Applications Extensibility 5.3" libary so you can code using the VBE, and use a macro to call a function like this:

Function CloseVBE()
On Error Resume Next
  Dim editor As VBE
  Set editor = Application.VBE
  editor.MainWindow.SetFocus
  SendKeys "%{F4}"
End Function

You can code [tt]editor.MainWindow.Close[/tt] but it will trigger an error. Using SendKeys simulates the user shutting down the window.

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[lmontes]

Thanks!!