Hi Experts,

I have an Excel file, MyTemplaye.xls, that serves as the template file. The template is in sheet2 which get its data directly from sheet1. Now, sheet1 in turn receives an exported data from a third-party database program. My desired output is that, when the user runs the MyTemplate.xls, the file should only activate the SAVE-AS function while deactivating the SAVE function. The reason for this is that I don't want the user to chose SAVE as it will also save the sheet1 data and thus create errors in the cell linkages and formula settings when such file is subsequently accessed again by the user.

Now, is there an option setting in Excel where i can choose to force deactivate the Excel's SAVE function (while activating only the SAVE-AS function) everytime the MyTemplate.xls is activated by the user?

Likewise, I must also be able to re-activate again the SAVE function in case I wanted to edit or update the template cell formulas?

Or if there is a better way to do it any advice will be much appreciated.

Cheers,

Kim