How to use send keys to unprotect VBA project

  • Thread starter Thread starter Guest
  • Start date Start date
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}"
 
You code works for me with Excel 2K.
Are you sure the password is correct ?
Where are you running this code from ?

NickHK
 
Back
Top