Thread: How to use send keys to unprotect VBA project
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
luvgreen luvgreen is offline
external usenet poster
  
Posts: 33
Default 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}"
Reply With QuoteReply With Quote