Thread
:
Macro to get to VBA Project Password
View Single Post
#
2
Posted to microsoft.public.excel.programming
Gary L Brown
external usenet poster
Posts: 219
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 With Quote
Gary L Brown
View Public Profile
Find all posts by Gary L Brown