MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

Hi

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