How to protect VBA code

[PG_Develop]

Hello, collegues

I have faced the following situation: I need to pass my workbook to another user and be sure, that he won't pass it to a third party. So, I would attach workbook to a USB encrypted key by API by macro.

But my question is how to protect this macro (which, I suppose, should be in ThisWorkbook location and execute on Workbook.Open event to check, whether the key is in the PC or not)? I have read about some VBA code "obfuscators", but I am not sure, whether I can obfuscate macro not in a module, but in ThisWorkbook location. Maybe you know some more efficient ways to protect the macro.

If you need some more input data and further clarifications, please do not hesitate to ask me in this thread

Thank you in advance!

 

[Mister H]

Hi: What about just protecting the VBA with a password? I am not sure if all you are doing is trying to prevent someone from seeing your codes. If so just password protect your project. If so just go to VBA Project (Alt + F11) and then select TOOLS and then VBAProject Properties... and then click on the PROTECTION tab and place a checkmark in "Lock Project for viewing" and then enter a password. DONT LOSE YOUR PASSWORD because you will not be able to get back into your VBA Project without it. I hope this helps.

Take Care,
Mark

 

[PG_Develop]

Hi: What about just protecting the VBA with a password? I am not sure if all you are doing is trying to prevent someone from seeing your codes. If so just password protect your project. If so just go to VBA Project (Alt + F11) and then select TOOLS and then VBAProject Properties... and then click on the PROTECTION tab and place a checkmark in "Lock Project for viewing" and then enter a password. DONT LOSE YOUR PASSWORD because you will not be able to get back into your VBA Project without it. I hope this helps.

Take Care,
Mark

Mister H,

Thank you for reply. Password would suit, but it is very easy to crack password protection of VBA module.. That's why I am looking for some advanced protection options, such as obfuscation of VBA code, etc.

Thank you,
PG_Develop