I have a master spreadsheet that I do not want users to overwrite. Is there
a way to force users the save the spreadsheet using a different filename?

Put it on a drive/folder that the users can't write to (may take some effort
from your IT folks).

Or (Not foolproof)...Mark the file as ReadOnly (using windows explorer). But
anyone could be able to change the attributes back if they have permissions.

Tom wrote:

I have a master spreadsheet that I do not want users to overwrite. Is there
a way to force users the save the spreadsheet using a different filename?

--

Dave Peterson

the file will be posted on site for users to download. So I was looking for
a way (possibly using vb) to prevent users from saving the file under the
same name once they download it. Putting it in directory the users can't
write to is not feasible because I can't control where they download the file
to. Also the second option is not foolproof enough. Any ideas?

Thanks


"Dave Peterson" wrote:

Put it on a drive/folder that the users can't write to (may take some effort
from your IT folks).

Or (Not foolproof)...Mark the file as ReadOnly (using windows explorer). But
anyone could be able to change the attributes back if they have permissions.

Tom wrote:

I have a master spreadsheet that I do not want users to overwrite. Is there
a way to force users the save the spreadsheet using a different filename?

--

Dave Peterson

I don't think that there is anything better than marking the file readonly (and
keeping a backup to reload the file when someone finds a way around the readonly
attribute).



Tom wrote:

the file will be posted on site for users to download. So I was looking for
a way (possibly using vb) to prevent users from saving the file under the
same name once they download it. Putting it in directory the users can't
write to is not feasible because I can't control where they download the file
to. Also the second option is not foolproof enough. Any ideas?

Thanks


"Dave Peterson" wrote:

Put it on a drive/folder that the users can't write to (may take some effort
from your IT folks).

Or (Not foolproof)...Mark the file as ReadOnly (using windows explorer). But
anyone could be able to change the attributes back if they have permissions.

Tom wrote:

I have a master spreadsheet that I do not want users to overwrite. Is there
a way to force users the save the spreadsheet using a different filename?

--

Dave Peterson


--

Dave Peterson