Who exactly are you making it secure from if you are not selling or creating a commerical app?

For most users VBA password is adequate protection for inhouse code.

You could look at xldna.
http://www.blog.methodsinexcel.co.uk/category/xl-dna/
http://exceldna.codeplex.com/