How to share VBA project protected?

[Akbarov]

Hello Dear Community,

I am going to share my vba file to someone. I want him to be able to run VBA code when he click button, but i don't want him to see , edit VBA.
I know it is possible to password protect VBA project, but will he be able to run code without password?

 

[Michael M]

Yes, he can run the code with password protection turned on !
VBA Password protection simply stops other people from seeing the code.

 

[Akbarov]

But if some kind of error/ bug happens, VBA force to open module, and asks for password

 

[Michael M]

True, but you have to ensure you have allowed for errors / bugs when you write the code...