Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to get to VBA Project Password
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to get to VBA Project Password
Sub TestMe()
Application.SendKeys ("%{F11}") Application.SendKeys ("%te") End Sub HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "Steven" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Project password | Excel Programming | |||
VBP Project Password | Excel Programming | |||
Lost VBA Project Password | Excel Programming | |||
VBA Project Password | Excel Programming | |||
Accesing vba project from wb that has vba project password protected | Excel Programming |