How Protect VB Macros in Excel

Excel allows you to password-protect the macros separately from the spreadsheet. However, there are plenty of password crackers available, so this level of security will depend on the honesty and technical skill of your client.

You need to set the VBA password through the VBA editor. In the Project Explorer pane, right-click on the project and ask for "Properties..." then click on the "Protection" tab.

Yes, right click your project go VBA Project Properties then Prtection check the Lock project for viewing and the put a password. Also, if you need to maked changes to your user form you have to unprotect the project first before saving and to advise your user not to save the file this will cuase the file to disappear.
Regards