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

In reality? No. At best you could make it a little difficult by protecting
the worksheet with a password, but password protection of workbooks and
worksheets is notoriously weak and easily removed.

If your worksheet is really a super dooper wonder tool of commercial value
and you want to do what you can to protect your intellectual property, then
you might look into some of the Excel "compiler"s on the market - do a Google
search for Excel compilers and you'll find some. Their quality varies, as
does their compatibility with all features of Excel, along with their price.
From the very little I've researched on them, they are also pretty much
unable to handle adding/deleting rows/columns on sheets in a dynamic fashion
- so if your process involves any of that, it's going to be difficult to find
one that will work for you. Also, these are not one-button solutions, you
usually have to do some setup and definition of input/output cells during the
compilation process. The other option is to recreate the functionality of it
in another language such as VB or C.

"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

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

Even making it difficult is OK, I was thinking running a macro (to ensure macros are enabled) which would then run a macro to check if the image e.g. logo is placed in a particular cell called logo? if not disable the worksheet by hiding them?

Thanks!

How do you run a macro to ensure that macros are enabled if macros aren't
enabled? Perhaps I didn't understand you.

You may have heard of the technique of hiding all worksheets except a cover
worksheet which displays a message that macros must be enabled to use the wb.
If the wb is opened with macros enabled then this cover worksheet is
automatically hidden and the others are automatically displayed via wb_open
event code. Then, when the wb is closed, the cover worksheet is automatically
activated and the others hidden via wb_beforeclose event code. So, if the wb
is opened with macros disabled then only the cover worksheet will be seen.

Regards,
Greg

"andyc" wrote:


Even making it difficult is OK, I was thinking running a macro (to
ensure macros are enabled) which would then run a macro to check if the
image e.g. logo is placed in a particular cell called logo? if not
disable the worksheet by hiding them?

Thanks!



JLatham;477472 Wrote:
In reality? No. At best you could make it a little difficult by
protecting
the worksheet with a password, but password protection of workbooks and

worksheets is notoriously weak and easily removed.

If your worksheet is really a super dooper wonder tool of commercial
value
and you want to do what you can to protect your intellectual property,
then
you might look into some of the Excel "compiler"s on the market - do a
Google
search for Excel compilers and you'll find some. Their quality varies,
as
does their compatibility with all features of Excel, along with their
price.
From the very little I've researched on them, they are also pretty much

unable to handle adding/deleting rows/columns on sheets in a dynamic
fashion
- so if your process involves any of that, it's going to be difficult
to find
one that will work for you. Also, these are not one-button solutions,
you
usually have to do some setup and definition of input/output cells
during the
compilation process. The other option is to recreate the functionality
of it
in another language such as VB or C.

"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
-




--
andyc