Hi,

I am more of an Access type, but your macros should be a "project" and you can password protect the "project"

Incidentally, it would help if you said which version of MS Office/Excel you are using

Cheers