I don't know of a way to prevent copying. You'd have to get the folder where
workbook is stored set up so that people can't delete the file and then set
the macos so that the workbook is disabled if the path doesn't match where is
should be.

"dazzag82" wrote:

Is there a way of preveting a user to copy an excel workbook to a different
folder location?

We have excel spreadsheets saved in our company network and the locations
are the one safe source of information. These workbooks contain data which is
linked to other workbooks so it is importnat the files are not renamed nor
moved to a different folder. No matter how much I communicate this, some
people insist on doing it.

I know there is VBA code which can disable the use of 'Save-As' so that the
files cannot be saved in a different location. However this does not prevent
someone from copying (CTRL +C) and pasting (CTRL +V) the file from one folder
to another. I need to keep the Save As function as I need to control the read
only and modify access passwords etc from the general options.

Apparently it is possible to write VBA code which contains the true location
of the file, and when the workbook is opened, it ckecks that if it was opened
from the specified location, and if not an error message or userform appears
informing the user that the workbook cannot be accessed and therefore
information cannot be populated. I have also been told that rather than a pop
up error message or userform, the worksheets which need accessed are hidden
and another worksheet will show instead with the error message.

Can anyone help with this. Thanks.

Darren