The only problem with events is that they are macros and anyone can open a
workbook and turn macros off.

They may not be able to get to the VBE code (???), but they can get to all
the worksheets...
(or some one could).

It all depends on the people...

For the most part - protection only helps prevent "accidents".

--
steveB

Remove "AYN" from email to respond
"Greg Wilson" wrote in message
...
I don't disseminate any of my projects but only produce them for work and
install them on our system. To prevent a staff member from taking one of
them
if/when they leave the company, I include code in the Workbook_Open event
that looks for a simple text file and code phrase inside that file. If it
cannot be found then it won't open. They can make copies all they like but
can't open them outside of this environment. The people who would take my
stuff arn't skilled enough to crack VBProject protection.

Regards,
Greg



"fallingrock" wrote:


Anyone have some idea, tricks, code, suggestions, examples of how to
reduce if not prevent Excel-based products (like an Excel Template)
from being used by a person who did not buy it (i.e., illegal copying
and sharing)?


--
fallingrock
------------------------------------------------------------------------
fallingrock's Profile:
http://www.excelforum.com/member.php...o&userid=25756
View this thread:
http://www.excelforum.com/showthread...hreadid=391909