Thread: Protection
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Auric__ Auric__ is offline
external usenet poster
 
Posts: 538
Default Protection

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.