Macro to open VB Editor

Posted by Dave on January 17, 2002 9:37 AM

How would I write a macro that opens the VB editor and then opens the Workbook_Open Sub for editing?

Posted by Jacob on January 17, 2002 11:54 AM

This will open the VB editor

Sub OpenIt()
SendKeys ("%{F11}")
End Sub

This should get you started.

HTH

Jacob

Posted by DK on January 17, 2002 2:39 PM

An alternative to the SendKeys method is this:-

Sub ShowVBE()
Application.VBE.MainWindow.Visible = True
End Sub

HTH,
D