Can I use VBA to Lock VBA where Password already exists?

[SusaninHouston]

I made a careless mistake and left the 'Lock project for viewing' box unchecked and sent out copies of one of my models. A project password already exists. I had just unchecked the 'Lock' box for my convenience while I did some annual updates, but then forgot to check it again before sending out the updated model.

I do have regularly scheduled VBA-driven updates. Is there any way I can use the update to re-lock the code on the base model?

 

[Artik]

To change something in a VBA project on a given computer the "Trust access to object model of VBA project" option must be selected. By default, this option is not enabled. Without this "trust" all your effort will be in vain. When upgrading the version, go towards replacing the entire file, not its code.

Artik