How to protect vba code others from modifying

[ashish mehra]

Hi,

How can I control my vba code from modification even if I share the file?

I google it but could not found the solution.

Regards,
AM

 

[Asheesh]

Ashish, See below

http://www.excel-easy.com/vba/examples/protect-macro.html

 

[ashish mehra]

The problem is I file I had to share should be password free

 

[Asheesh]

This password is not a workbook password..and user can use the workbook as they want or as you let them using VBA..so where is the issue..

 

[ashish mehra]

I am referring to VBA Project Properties.

Regards,
AM

 

[Deepak]

@ ashish mehra

In a complicated situation choose as per need!

http://www.crunchcode.de/en/WhyObfuscating.html

http://www.spreadsheet1.com/secure-vba-compiler-for-microsoft-office-excel.html

http://doneex.com/index.php?option=...10&Itemid=43&gclid=CKSepamRi6cCFQlPgwodbSTAeA

http://www.mrexcel.com/forum/excel-...ications-vb6-create-then-dll.html#post2584257

 

[Marc L]

Hi !​

I am referring to VBA Project Properties.

You can password protect at VBA project level only,
it's not the same password as workbook neither worksheets …
​

 

[ashish mehra]

Thanks Deepak & Marc

@Deepak
I am going through all the links.

Regards,
AM