Macro to get to VBA Project Password

G

Guest

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
 
G

Guest

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

HTH,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Project Password Changed on its own?!?! 0
Excel VBA Project Has Protection? 2
Programmaticlly sign and password protect a VBA Project in Excel 2 6
Excel VBA Project Excel Lost ! 1
Macro Protection 3
Macro to lock project from viewing 1
Knowing is a workbook's VBA project has password or not 2
vba project password 4

Top