Protect Excel user form code

[Apple08]

Hi everyone

i have created an Excel user form but data don’t need to store in any Excel workbook. All I want to do is to protect my userform code from viewing or editing by users but allow users to input data in the user form.

Please could anyone tell tell me how can I protect the userform code? Many thanks.

 

[KKaren]

To protect your codes with a password and hide them for other users - in the VB Editor you can choose the Tools menu and then VBA Project Properties.
Then on the Protection tab you can check "Lock Project for viewing" and provide a password on the 2 textboxes below.

Thus, the next time you open the workbook when you enable the VBE, you will be prompted to provide the password for it when you click in the relevant project in the Project Explorer section...

 

[JLGWhiz]

If you forget your password, you will also be locked out. But this is not a foolproof mehtod of protecting your code against hackers who are determined to steal it. It will protect against the casual user being able to open the code modules through the vb editor.

 

[Apple08]

Thank you both! It works perfectly