Block a excel file from being copied?

  • Thread starter Thread starter SG Hurst
  • Start date Start date
S

SG Hurst

I am trying to stop others from saving a file under a different name. Is it
possible?
 
Not really.

Users can copy the file using windows explorer. And anything I could do to make
sure that it's where it's supposed to be (and named correctly) would rely on
macros. And macros can be disabled.
 
Perhaps "hide" everything in the file, and then have auto-open macro
check file name and location, if success, unhide?
 
Perhaps...

But if the user has to update the file and then save it, you'd have to
complicate matters (a whole lot) by saving the file with all that stuff hidden.

And with the protection that's offered by both worksheet and workbook protection
(tools|protection type), it's still not too secure.
 
Saving, copying and everything else to do with storing or deleting files is
handled by your operating system. XL really has no say in the matter.
 
It definitely would be messy, I guess it depends on the situation the OP
is attempting to "cure".
 
Back
Top