Add VbaProject password via VB code

[pandpp]

Hello,

It's been a while, but I have previously added VBA code to an Excel project via VB.

What I am now seeking is guidance on how to protect, via a password, the Project code, from within VB.

I have found the Protection property of the VBComponent within the "Microsoft Visual Basic for Applications Exrtensibility 5.3" object, only, it is a read only property.

Does any one know if there is a method available to protect the VBA code?
I need to put a DB Super User username & password in the code & obviously want it relatively safe.
I can't lock the code manually, since the password is going to change over time, hence the dynamics.

Thank you in advance for any suggestions.

Peter.

Excel 2002

 

[TonyJollans]

Hi Peter,

AFAIK the only way to do this is with the Project Properties dialog and Sendkeys. I'd be interested to see another way but if no-one comes up with anything, I'll see if I can root out some code. But I don't really understand what you are trying to do - are you wanting to periodically run against, say, all Workbooks in a Folder and change the password or something similar?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[