Does anyone happen to know if there is any way to share password protected VBA content from one to another? I have several macros that I am trying to share with others in our company but wanted to protect my work (to ensure others do not mess around with the code).



I can right click on the individual Modules, select the “Project Properties”, Lock the project for viewing and assign a password. After assigning the password I have closed out of the VB editor and confirmed that I have to enter in a password to view the content. However at that point I can no longer export the data. I see someone else has asked about this before but it appears that it was a concern only on the current computer in-use: https://www.msofficeforums.com/word-vba/16357-secure-macro.html

If I enter the password in, then export the Module(s) I can once again export the data to a .bas file. After transferring the .bas to a different computer, opening the VB editor and importing the file the password protection is gone. All code can be seen, edited, etc.

Also have attempted creating different document types then import as an Add-in to Word on the other machine. So far I have not been able to find a document type or way to transfer everything but still keep it protected. I wonder if this simply isn't a possibility due to security reasons.

Hopefully I have just overlooked some simple feature. Any help would be thoroughly appreciated!

Hi Duvdev,

When distributing protected code, the idea is to distribute it in a carrier document or template. That way the protection remains intact. This is a quite common approach taken by 3rd-party addin developers.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

If you distribute it as a template (global or document) with the code protected, it will remain protected. Obviously, a .bas file is a text file and protection will not apply to that.