In the VB Editor right click on the module name and choose the VBAProject Properties item from the list.
Select the Protection tab and tick the lock project for viewing.
Put in the password and confirm it.
This will lock the project against viewing.
Note that you will have to close the file in Excel and reopen it for this to take effect.