XL just doesn't have this capability. If the user can open the file,
they can generally gain access to everything in it, including hidden
sheets, protected code, etc.

It may be technically feasible if you have access to their machine (to
get some identifying number), and if you compile all your workbooks into
COM add-ins. Otherwise, you can throw up roadblocks, but they won't keep
someone who is motivated, with even moderate abilities (i.e., they can
find this newsgroup), from bypassing them.

Having an installer that installs a hidden file or registry key upon
which the app is dependent is also a possibility - it won't prevent
someone from giving away your installer, but joe user wouldn't be able
to simply copy the folder.

As for your proposed protection scheme, though, I certainly wouldn't buy
*anything* that I needed for my business that licensed a single machine
- what if the machine fails and I need to use an alternate? Or what if I
want to upgrade my machine - I'd have to get permission from you? No
way! Some of my Windows clients put up with that BS from Microsoft (lord
knows why), but not an independent contractor.

I'm also troubled by your desire to make your client "feel sorry". If by
"feel sorry" you mean to put up a message saying "This may be an illegal
copy, you should feel very very bad", while I suppose that's something I
could live with, seems unprofessional.

But if by "feel sorry" you mean to damage anything I have on any of my
machines, if that happened, I'd sue you for everything you've got. You
have a right to compensation for your work - you don't have a right to
damage *anything* of mine, even if I steal from you.

Far better to get to know your clients and establish a relationship
whereby they're willing to pay a reasonable price for additional desks,
and for continuing support. Make it clear that this is a licensed
product: put in passwords that are specific to your client, and make
sure all your dialogs list both the client and you. Compile it if it
doesn't need to either be cross-platform or to run on XL97.

That won't prevent piracy, but if you charge a reasonable price and
provide great service, ethical clients will respect your license.


In article ,
ysaneo wrote:

Could anyone come up with a functional code (the SOLUTION in my case)
that will ‘import’ actual computer ID (serial number or something)
into Excel, check if it is the same one as the one written in the macro
and IF NOT disable all workbooks opening functions and/or quit Excel
application – i.e. close Excel altogether? The idea behind is that my
XL files could run only on one computer – sort of soft-key. If files
are copied and user wants to run it on another computer to make him
feel sorry.