However, there's no easy tool that I know of??? Plus, if you've written code
say for Excel, if you're running it outside of Excel with VB, you'd have to
rewrite much of it since the original code would work directly with the
Excel Object Model...which wouldn't be active in an EXE. So you'd have to
rewrite much of it. It would probably be a hassle...if it even worked in the
end, anyway.
Sure, you CAN buy hacking programs that go through all possible combinations
in order to break into the code, but the harder you make the pass, the
longer it will take...several days or more depending on the software you
might buy. And remember, that users would have to give their credit card
number to hackers to get the software...not something I'd bother to do for
code!
And there's probably a good chance that anything you've written is somewhere
on the web for free in support groups...that others could work out anyway
with time.
The bottom line is that if you make the pass a complex one, the chance that
anyone would bother to get the software and take the time to bust into your
code seem pretty slim...a lot less than the hassle you'd take to try to
create an EXE. Use a pass with a lot of mixed letters and numbers in both
upper/lowercase and make it long. Just don't forget your pass or you'll be
fighting to get into it.