Hi All

I have a big workbook and I am trying to protect the
macros so that people carn't change them or take my code.
Is it possible to entirely stop people from access these?

Currently I have a password on them but am aware that you
can just download a password sniffer to get the password
and I was hopeing for a little better security than that,
maybe rolling them into a dll file or something like
that. But I have no idea where to start on any of this a
punt in the right direction would be great

Jase

On Thu, 19 Feb 2004 19:08:57 -0800, Jase wrote:

Hi All

I have a big workbook and I am trying to protect the
macros so that people carn't change them or take my code.
Is it possible to entirely stop people from access these?

Currently I have a password on them but am aware that you
can just download a password sniffer to get the password
and I was hopeing for a little better security than that,
maybe rolling them into a dll file or something like
that. But I have no idea where to start on any of this a
punt in the right direction would be great

To roll your own DLL you need a compiler. If you get VB (5 or 6
recommended), you can drop your VBA straight into it with very little
modification. Pre-.NET VB is available on auction sites like eBay.
--
auric "underscore" "underscore" "at" hotmail "dot" com
*****
Why did the chicken cross the road?
SAEED AL SAHAF, Iraqi Head of Information:
The chicken did not cross the road. This is a complete fabrication. We
do not even have a chicken.

nothing is impenetrable BUT there is a real good utility that you can
use to totaly lock the code (this also means you can not access it
either - so make sure you have a back up).

It's available through the same people that sell you the password
breaking code - http://www.lostpassword.com/excel.htm

Do a searh for VBALock.exe

Thank You!
Bill

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!