save as different filename

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I prompt user to select item and use as a variable 6
searching filenames 1
How to add Date Stamp to SaveAs "file name" within VBA for Excel? 1
File save as 1
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
file name as specified cell when save as or save is clicked 6
Saving a Word document as PDF from en Excel macro 2
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0

Back
Top