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

Have you tried simply removing "Save As" (and Send To) from the File menu
from the workbook?

"CCrew2000" wrote:

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?