Removing a KNOWN VBA password via VBA

If you have already elminated SendKeys as an option, then you're out of luck. VBA does not expose the VBProject passwords in its object model. The only workaround is to use SendKeys to simulate you manually unlocking the project.

If you Google you'll find many SendKeys techniques offered (the link above by Winon is good), and widely criticized as SendKeys is notoriously unreliable. I would not put this technique into a product I was giving OTHERS to use, and might only use it myself in the rarest of instances.

I'm also going to watch this thread closely. If anyone breaks the forum rule regading offering solutions that overcome Excel's builtin securities, I'll shut this discussion down. Ok?