Is this possible: Give someone a VBA Macro Workbook but...they can run the script, but cannot view the VBA code?

[pivotpp]

Essentially have a VBA workbook where it allow the user I am giving it to to enter simple parameters like enter something in cell A1 and A2, press Enter and it will run my script and performance a task. But they are not able to go into the VBA editor or see my VBA code.




Is this possible? Any place I can learn more?




Thanks in advance

 

[mole999]

you can put a password on the script module which partly achieves your goal, for most this is suitable, but won't stop those who really want to get in

 

[pivotpp]

Thank you.

What are some ways someone might bypass the password?

 

[MARK858]

There are a few ways but it is against the forum rules to give any info on bypassing passwords or any other security

 

[pivotpp]

Ah fair enough, and wasn't my intention to be clear.


Just wanted to know the difficulty of bypassing a password to get VBA source code

 

[MARK858]

Ah fair enough, and wasn't my intention to be clear.


Just wanted to know the difficulty of bypassing a password to get VBA source code

Depends on their knowledge, it is not something that the average Excel user would stumble across but for example there are plenty of experienced VBA users on this board who would know how to bypass the password.