Secure / Protect Your Macro

[aequitas1903]

Hello,

I search the forum but can't find a thread which informs how we can secure our macros. Maybe it is so easy but I am a newbie Is there an option in excel developer section or a code that can protect my macros to be taken from anyone or can I set a master password to "Step into" macros.

I need your help because I am going to share a .xlsm file that includes macros in workbook. I dont want anyone to take that macro from the workbook to their personal.xlsb . They can use it in the excel file but can't take it

Thank to you guys.
Regards

 

[VoG]

In the VBE, Tools > VBA Project Properties, Protection tab tick Lock Project for Viewing and enter a password. Save, close and re-open the workbook to see the effect.

 

[aequitas1903]

Thank you so much VoG. Just figured it out and came here to say I found it but you are faster than me Thank you so much again for your help.