I have set up on a shared drive a file that has been moved by someone else. I
found the file and returned it to its rightful place but wish to make sure it
cannot be moved again. Is there a way of fixing its location to one directory?

I don't think you can stop them.

You could use a macro that checks for location when the file opens, but macros
can be disabled.

If the workbook is not saved by the user, then you could talk to your IT Staff
to put it on a readonly network share. But this won't stop them from copying
the file to another location.

If the workbook is saved by the user, then the readonly network share won't work
either. They'll need read/write/create/delete permission to update the file.

I think it boils down to a training issue and keeping lots of backups that you
can restore from.

hallday wrote:

I have set up on a shared drive a file that has been moved by someone else. I
found the file and returned it to its rightful place but wish to make sure it
cannot be moved again. Is there a way of fixing its location to one directory?

--

Dave Peterson