Turn off Save Feature
 

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

Turn off Save Feature
 

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" wrote in message
...
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