I have an Excel project distributed to several hundred users that is self updating. When launched, it compares it's version number to a current version number on a remote server. If the numbers don't match, all of the modules and forms in the project are replaced with the most up to date versions.

My problem now is that the project needs to be locked down due to some users editing code to circumvent certain controls. If I lock the project for editing or viewing, my modules can't be changed during one of the automatic update.

I can view the current locked state of the project with the following property:
Application.VBE.ActiveVBProject.Protection

Unfortunately the property is read-only.

Is there a way with VBA to unlock a password protected project, allow the necessary changes to occur and then relock it?