I was just wondering: It is possible to create a click button in VBA Excel that opens the VBA editor when the button is clicked?

UPDATE: The point that I was looking for was achieved by @pgSystemTester. In this, I don't have to disable the trust settings, as suggested by another answers pasted here below. Very better way.

CodePudding user response：

In response to the comments, it seems hard to envision a situation where it's a good idea to be directing "inexperienced users" to the visual basic editor. Similarly, lowering these same users' systems' defenses against malicious code seems unwise.

With that said, you could just try to teach your users to type: alt L V

I don't like keystroke macros, but this actually seems to work for me:

Sub OpenVBE()

   Application.SendKeys ("%lv")

End Sub

This appears to work without lowering the users' trust settings also.