Setting password in Excel programatically from VB app

[3576]

Does anyone know if it is possible to to set a password for modules and lock project for viewing in Excel programmatically from VB app.

Thanks in advance.

TW

 

[borgunit]

If this is your AutoCAD VBA project, just right click on the project name from the vb editor and set it properties to be password protected. Is this what you are looking for?

 

[3576]

I posted my message in the wrong forum but I want to set a password from a VB application as I am creating and formatting an excel workbook and attaching a module everytime a special list is generated using VB app. I would like to protect the code so that users won't modifying it.
I know that I could do it manually in Excel but the problem is that the user will be generating the excel workbook.
Any ideas?

Thanks,

TW

 

[borgunit]

If this is a vb project then the answer is no. This feature (or lack of) is done on purpose so that protecting and/or unprotecting cannot be coded by hackers to decrypt or break into code.