Quote Originally Posted by trekrtwo
Is it possible to actually protect macros from viewing in Office apps? It looks like there are a hundred cheap password crackers that claim to break any password I might create.
Can you stop someone from getting access to view your code? No. Period. Office is not a secure environment for code at all. A knowledgeable person can access your protected code in less than five minutes. The only need to know what software to download, and it won't even cost them a dime.

Quote Originally Posted by trekrtwo
I'm using Office 2002. Is the new version more secure?
No. Nor is 2003. It will be interesting to see if the next version imparts any more security though.

If you want security, and you are above 97, you may want to try compiling a dll file using Visual Basic. That will protect it, although I believe that even those complied addins can be decompiled by someone who knows their way around it.

Fact of the matter is that if your code is that confidential, you shouldn't be in an office app.