Macro to get to VBA Project Password

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven - 20 Jan 2006 16:40 GMT

I recently learned that you cannot programmatically change the VBA Project
Password. I like to password the VBA Editor so when I make a change to the
code I have to go the long way around to input the password. I was wondering
if there is a code that will at least open the box to input the password. It
is such a pain to Click Tools / Macro / VB Editor ... then Tools / VBA
Project Properties.

Thanks for your help.

Steven

Reply to this Message

Gary L Brown - 20 Jan 2006 18:40 GMT

Sub TestMe()
Application.SendKeys ("%{F11}")
Application.SendKeys ("%te")
End Sub

HTH,

Signature

Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.

> I recently learned that you cannot programmatically change the VBA Project
> Password. I like to password the VBA Editor so when I make a change to the
[quoted text clipped - 6 lines]
>
> Steven

Reply to this Message