You can lock the project (Tools - VBAProject Properties) - Protection tab -
Lock project for viewing. The password algorigthm it uses is likely no more
secure than other passwords in Excel, but will keep out the mildly curious).
Many people make their living by writing code. If they (and others) choose to
try to protect their intellectual property, why should you have access to it?
Even if you say this is for your own project, how would anyone know if that's
true?