View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default Unlock Protected VBAProject via code

Thanks Bob

EM

"Bob Phillips" wrote:

Sendkeys is the only automated way that I know of.

--
__________________________________
HTH

Bob

"ExcelMonkey" wrote in message
...
Is there a way to unlock a VBAProject via code other than using the
SendKey
method?

The reason I ask is that I have a large number of file to go through which
have projected VBAProjects. The users are providing me with the passwords
in
advance. I simply want to automate the process

Thanks

EM