can you hide macro code??

[Guest]

Hi,

I have some user forms and there is macro code associated
with them. Is it possible that the user be UNABLE to see
the code? ie. the code be inaccessible to them?

 

[Jack Schitt]

In VBA editor, select from menu bar
Tools/VBA Project Properties .../Protection tab, check the box "Lock project
for viewing" and add a password.

CAUTION: This is not secure. Password crackers for this level of security
are ten a penny. Better to compile your code as an add-in. Don't ask me
how to do that.

 

[Jonsson]

Hi,

In VB, choose Tools, Properties, Protect.
There you can choose your password, and then you make sure to choose option
"Hide".
Close the program, open it again and press F11 to get to VB.
Now you have to write your choosen password to be able to see the code.

//Thomas