Is there any way to really prevent users from viewing VBA code? I am told that passwords can be cracked easily enough.

I appreciate any input.

Thanks

Passwords aren't that easy to crack, although I'm told determined hacker can get in. I've yet to have a problem within my firm (1000+ people), but I do not publish/sell outside. If you are really worried, you may need to write VB6 applications that are add-ins, rather than working in VBA.

Dave

Thanks a million Dave. I hope to sell a program to banks and have thought about recoding the application in VB.net. Your reply has further prompted me in that direction.

I made a similar enquiry to the beginning vb.net forum, asking about password security with EXE files...

http://p2p.wrox.com/topic.asp?TOPIC_ID=10548

...and discovered that if someone really wants your code they can basically get it if they have a copy of your software. I'm no expert but if you want security of code you probably need to be looking at encryption.

it's always been said,

if someone wants it bad enough they will get it.