| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA password protected modules
Is there any way I can unlock a password protected macro so I can update it
using VBA? Obviously I know what the password is, but the file has been distributed around the Group and it would be more convenient for the users to have this updated rather than reissued |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VBA password protected modules
It can be done, but it involves the use of SendKeys which isn't too stable.
This is an example, but you may need to tune it With Application .SendKeys "%{F11}", True ' VBE .SendKeys "^r", True ' Set focus to Explorer .SendKeys "{TAB}", True ' Tab to locked project .SendKeys "~", True ' Enter .SendKeys "password" .SendKeys "~", True ' Enter End With -- HTH Bob Phillips (remove nothere from email address if mailing direct) "MikeFullam" wrote in message ... Is there any way I can unlock a password protected macro so I can update it using VBA? Obviously I know what the password is, but the file has been distributed around the Group and it would be more convenient for the users to have this updated rather than reissued |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
| insert password protected spreadsheet | Excel Discussion (Misc queries) | |||
| how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
| Linking to a Password Protected Document in Excel 2000 | Excel Discussion (Misc queries) | |||
| bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
Linear Mode
