Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba project properties via code
I have a rather large group of files to modify. The vba modules of each are
'nearly' identical, and I need to add or remove code from each one. I have the code in place to modify them, but each one has their vba project password protected (al with the same passord). How do I pass the password to the project from within my code to unlock those other projects before I modify them. (Note I do not wish to remove the protection, just open the projects, modify and get out again.) If I open them and unlock manually, it could take me days, and the point of my project is to do this in a matter of minutes, to force them all to use the same external code for their processing. Thanks!! Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Project Explorer and Properties window (VBA) have disappeared | Excel Programming | |||
Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
Workbook with no properties attaches itself to my VBA project | Excel Discussion (Misc queries) | |||
VBA Project Properties | Excel Programming | |||
Locking VBA code via Project properties but cannot save the workbook over itself | Excel Programming |