> Are your macros *so* valuable that your clients will pay you to
> hard-code their drive serial # into a compiled add-in, leaving
> themselves crippled if they have a hard-drive crash?
Value is relative.
I would implement a routine that gave them a 30 day introductory period,
during which they send me an email with a code provided by the program. This
code would be some kind of crypto of the HD serial number and the date of
initial use or date of renewal. I would input this code into a routine on my
computer which would spit out another code, which they enter into a
registration screen. Their copy of the program would accept the returned
code, compare the unencrypted HD SN with the HD present on their machine,
and if it matches, it would add 12 months to the expiration date.
> And if you're not planning on distributing them in a COM add-in, adding
> protection is rather useless - it takes about 30 seconds to disable VBA
> protection.
30 seconds for you or me, 10 minutes for Michelle, and an indeterminate time
for Joe Client.
Granted, for a generally trustworthy client, none of this is necessary. But
Michelle may have a sleazoid on the line. In fact, I developed a similar
system for a client who had some sleazoid clients who wanted to ignore the
EULA and install one licensed copy of a large package onto dozens of
machines.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______