| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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}" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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}" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can project unprotect self? | Excel Programming | |||
| protect/unprotect a VBA Project | Excel Programming | |||
| protect/unprotect a VBA Project | Excel Programming | |||
| Using Send Keys to unprotect and protect VB project | Excel Programming | |||
| Protect\Unprotect VBA project | Excel Programming | |||
Hybrid Mode
