04-08-2014, 12:35 PM
|
|
Novice
|
|
Join Date: Mar 2014
Posts: 4
|
|
Possible to Protect / Hide VBA Macro Code When Transferred to a Different Computer?
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!
Last edited by Duvdev; 04-08-2014 at 12:36 PM.
Reason: Make it easier to read
|
Similar Threads
Can't send a macro file to another computer
Windows 7 64bit 
Office 2010 64bit
Threaded Mode