VBA model password

[habfan]

I have an issue in using another piece of vba to make changes to several other excel workbooks vba code. The other vba projects are password protected, I know the password to the vba, but I do not know how to open the other vba sources and pass the password to it. Any Ideas.

Thanks

 

[rmikesmith]

I don't believe there is any way to accomplish this through code (probably a security issue). Your only alternative is to manually remove project protection prior to running your code.


Regards,
Mike

 

[pbazsmir]

There's a way to solve the problem! Of course, if you know the VBProject Password.

Try the idea from: ProtegerDeprotegerVBAProject