View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Edmund Edmund is offline
external usenet poster
 
Posts: 17
Default Protect file from being overwritten via "save as"


Set the file as read-only. Or you can get the System Administrator to make
that network folder read-only, since savy users will simply set the file to
read-write and then save over it (if any of your users are that savy).

"CCrew2000" wrote in message
...
Is there a way to prevent someone from saving over a specific file?

I've created a file on a network drive for some users. Some of the users
complain about the time it takes to open the excel file. What they've
done
is save the file to their C:\ once the file is open. Make their changes
and
then "save-as" back to the network drive (thus overwriting) the original
file.

How can I prevent them from saving over my file with their "new" file?