| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AutoComplete feature - Turn off | Excel Discussion (Misc queries) | |||
| Turn off Research feature | Excel Discussion (Misc queries) | |||
| How do I turn off security feature for hyperlinks? | Setting up and Configuration of Excel | |||
| how to turn on and off autofill feature in 2000 | Excel Discussion (Misc queries) | |||
| In code be able to turn on/off Track Changes feature? | Excel Programming | |||
Linear Mode
