|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can't send a macro file to another computer | norwood | Word VBA | 3 | 02-04-2014 08:15 PM |
300 dpi PPT images to be transferred to MS-Word... | bharosey | PowerPoint | 1 | 01-23-2014 05:10 AM |
VBA Code for adding Macro to QAT | OTPM | Project | 4 | 08-22-2013 01:33 PM |
Indentation of word document not transferred to Kindle format | Microsoftenquirer1000 | Word | 1 | 10-09-2012 05:26 AM |
Assign macro but hide the button/field | trlear | Word VBA | 5 | 02-23-2012 04:35 PM |