theta
07-06-2012, 07:52 AM
I have several (dozens) of VBA projects within the VBE. When I open the trigger workbook, it opens up several other workbooks with their own modular VBA components - this all comes together to form a product.
I need to search all modules for a few hard coded strings that need to be replaced - is there a macro available to quickly unprotect all projects in the VBE?
They all have the same password so I can enter this into the code / inputbox
Any help appreciated, will save me alot of time! I cannot remove the passwords as they are shared, I just need to be able to unlock them when needed with the minimal of fuss.
I need to search all modules for a few hard coded strings that need to be replaced - is there a macro available to quickly unprotect all projects in the VBE?
They all have the same password so I can enter this into the code / inputbox
Any help appreciated, will save me alot of time! I cannot remove the passwords as they are shared, I just need to be able to unlock them when needed with the minimal of fuss.