It definitely would be messy, I guess it depends on the situation the OP
is attempting to "cure".

Dave Peterson wrote:
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.


Bob I wrote:

Perhaps "hide" everything in the file, and then have auto-open macro
check file name and location, if success, unhide?

Dave Peterson wrote:


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.

SG Hurst wrote:


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