Lock vba code in new workbook

[VHS01]

I spent a great deal of time going through posts, but could not find anything directly related to this.

Presently I have the vba code passworded on my workbook

Periodically, I export the code for the module, create a new workbook using the "Workbooks.Add(xlWBATWorksheet), import the module to the new workbook, and kill the exported files.

Trouble is the new workbook's code is not protected.

Can passwording the newly created workbook's vba code be done programatically?

 

[Tazguy37]

See Ivan F Moala's post here for one method.

Hope that helps!

 

[VHS01]

Thank you Tazguy37