Password Protect Code Module Using VBA Code

[NeedForExcel]

Hi,

Is there a way to Password Protect Code Module Using VBA Code?

I have a code that generated multiple Workbooks with codes in it.. I just want to password protect the code modules while the Workbooks are being generated.

Anyway of doing it?

Cheers!

[BanginMyHeadOnMyDesk]

I'm not sure there is a simple programmatic method of locking the VBA project using VBA.
You could do it with a list of SendKeys commands to simulate the process being carried out manually.

Beth.

[NeedForExcel]

Hi,

Thanks for the reply..

I actually knew about that solution.. Just wanted to know if there is a better way..

I have been reading about it and I understand that there is no way to do it using any exposed properties.

[romperstomper]

You can use APIs which are a little more reliable than sendkeys, but there's no simple method.

[NeedForExcel]

Hi rorya,

Thanks for the response, and apologies for the delay in responding.

Can you direct me towards any such API which can probably help me?

Cheers!
Deep

[romperstomper]

Here's an idea of the APIs you need: http://www.standards.com/Office/SetV...tPassword.html
It would need some adapting to use from Excel rather than VB6.