Remove VBA - Password (not by hacking!)

[dh_ander]

For data migration purposes I need to alter "path" statements in VBA code in Excel sheets.
Sometimes the VBA code is protected and I need open the VBA by entering a known password or check from a list of passwords.

Since we speak about tens of thousand of sheets this can't be done on a individual basis anymore.

Any suggestions for some code to automate this proces?

Thanks in advance
David

 

[RoryA]

You would need to adapt something like this which is code to lock the project.