How to use send keys to unprotect VBA project
 

Hello all,

I have trying to use send keys to unprotect VBA protect. I am stuck with
password box showing up without taking the password I use send keys. Any
suggestions? Thanks so very much!! I tried with Application. and
Interaction., both of them stuck with password box popping up. Thanks.

Interaction.SendKeys "%{F11}"
Interaction.SendKeys "^r"
Interaction.SendKeys "{DOWN}"
Interaction.SendKeys "password"
Interaction.SendKeys "{ENTER}"

How to use send keys to unprotect VBA project
 

You code works for me with Excel 2K.
Are you sure the password is correct ?
Where are you running this code from ?

NickHK

"luvgreen" wrote in message
...
Hello all,

I have trying to use send keys to unprotect VBA protect. I am stuck with
password box showing up without taking the password I use send keys. Any
suggestions? Thanks so very much!! I tried with Application. and
Interaction., both of them stuck with password box popping up. Thanks.

Interaction.SendKeys "%{F11}"
Interaction.SendKeys "^r"
Interaction.SendKeys "{DOWN}"
Interaction.SendKeys "password"
Interaction.SendKeys "{ENTER}"