How to use send keys to unprotect VBA project

G

Guest

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}"
 
N

NickHK

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

NickHK
 

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

Top