you will need to protect the macros themselves so they cannot be
viewed without a password
(tools vba project properties protection lock project with
password).
Then make the macros begin with a line that says :
if inputbox("Please enter the password")<"password" then exit sub

replace <"password" with < whatever the password you want them to
type.