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".
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excell 2021 0
VBA - retrieve data on last create named range from previous inserted named range 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
blocked file format 2
PowerPoint High Resolution Images from PowerPoint 0
Excel And Notepad 3
How do I stop Excel 2007 from creating backup copies? 2
Changing default fie for backup saving 2

Back
Top