How do you password protect entering the vba code

问题:

I want a method that will password protect my vba code, so that users in the sheet won't be able to go into the code editor without entering it.

回答1:

You can protect your vba code by a password as described here: http://www.ozgrid.com/VBA/protect-vba-code.htm

But this is not the most secure way to protect your code, see this thread for more information: Lock down Microsoft Excel macro