If you are like me and write stuff for your employer that is less than "a
super dooper wonder tool" of immence commercial value and your concern is
that an employee will 1) take it with when they leave to join another firm or
2) disseminate it by various means, then you might consider the following.

Add wb_open event code that looks for a certain text file on a network
drive. The file may contain a code string if you like. In other words, this
file is effectively a cookie. If the file is not found (and optionally, if
the code string inside the file is also not found) then post a message that
the program is not licenced to work on the current system and close the
workbook. *** This assumes that the code is the most important (or essential)
part of the project. They can of course just open it with macros dissabled
and still benefit from the formula and worksheet layout.

Note that this is also easily circumvented by moderately sophisticated
individuals who know how to crack the VBA project, or know that you can and
are motivated enough to search. Breaking the VBA project is still much more
difficult than breaking worksheet and workbook protection which is trivial.
The motivated will still find a way, but colleagues typically care a lot less
than we like to think <g.

Regards,
Greg



"andyc" wrote:


Hi,

Is it possible to prevent an image from being removed or deleted from a
sheet, its our logo and need to ensure the workbook is not copied etc.

Thanks,

Andy




--
andyc