Macro to call Visual Basic Editor?

[ArthurReyes]

I have a custom admin button on my toolbar. .OnAction is set to "AdminMode"

I want the AdminMode() Sub to open the Visual Basic Editor.

 

[Mudface]

Try: -

Public Sub AdminMode()

Application.VBE.CodePanes(1).Show

End Sub
This message was edited by Mudface on 2002-12-10 15:24

 

[ArthurReyes]

interesting, if I have no code panes open when I close VBE, on runing AdminMode nothing happens.

 

[Mudface]

Sorry, this should work OK: -
<pre>
Public Sub AdminMode()

Application.VBE.MainWindow.Visible = True

End Sub
</pre>

 

[ArthurReyes]

This worked better, thanks for the lead:

Application.VBE.ActiveVBProject.VBComponents(4).CodeModule.CodePane.Show

 

[ArthurReyes]

. . .because it takes me to the exact module I'm interested in. . .<sorry for the stupid double post>
This message was edited by ArthurReyes on 2002-12-10 15:49

 

[Maurizio]

With a macro named -> Raggru <- try:

Sub SeeMacro()
Application.Goto Reference:="Raggru"
End Sub

 

[PatrickOfLondon]

Thanks to all for helping with this, and especially to Maurizio.

Being able to open a particular macro directly by "Go(ing)To" its name is brilliant, and was unknown to me before I found this.

(Before anyone mentions that this thread is nearly 20 years old, I always wonder why people make that kind of comment. So long as applications work the same as they did years ago, people will continue to stumble across the same problems, and ask the same questions about them, and be glad of finding the same answers.)

 

[mcbishop]

Another thanks to Maurizio for the exciting macro statement.
I sooo agree with PatrickOfLondon. ...That forum-shared code tends to work 20 years later is a big strength of VBA.