| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protected Projects
Anyone know how to unlock a VBA Project Programatically?
I am trying to write a patch to automatically update a workbook that has gone out to loads of people but needs an extra piece of code adding. I want to issue them a "patch" that when you click a button, opens their workbook, unlocks the project and adds the new code. My only stumbling block is getting the project unlocked. The rest is ok! I know the password on the project but can't seem to find a way to unlock the it Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protected Projects
Only way it the unreliable SendKeys.
-- Regards, Tom Ogilvy "SkiBum" wrote in message ... Anyone know how to unlock a VBA Project Programatically? I am trying to write a patch to automatically update a workbook that has gone out to loads of people but needs an extra piece of code adding. I want to issue them a "patch" that when you click a button, opens their workbook, unlocks the project and adds the new code. My only stumbling block is getting the project unlocked. The rest is ok! I know the password on the project but can't seem to find a way to unlock the it Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with projects | Excel Discussion (Misc queries) | |||
| Same variable name in different projects | Excel Programming | |||
| Securing VB Projects? | Excel Programming | |||
| How to become a better programmer, post college. More projects or less projects. | Excel Programming | |||
| How can we share more projects? | Excel Programming | |||
Linear Mode
