Turn off Save Feature

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

Guest

I have a spreadsheet that has a macro that imports data into the spreadsheet. I want the user to save the file as another name. I don't want the user to be able to save the file. I want them to only have the SaveAs option, not the Save option. Is there an easy way to turn off the Save function when they open the workbook? Thanks. Matt
 
Well, if you save the workbook as read-only, the users will be forced to use
the SaveAs option. In XP, use SaveAs | Tools | General Options | Password to
Modify.

--

Vasant

Matt said:
I have a spreadsheet that has a macro that imports data into the
Click to expand...
spreadsheet. I want the user to save the file as another name. I don't
want the user to be able to save the file. I want them to only have the
SaveAs option, not the Save option. Is there an easy way to turn off the
Save function when they open the workbook? Thanks. Matt
 
Back
Top