#1
|
|||
|
|||
How to "deactivate" the Excel's SAVE function
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 |
#2
|
|||
|
|||
Have you ever tried to open the drop down list in save -as menu?
You will find there the option : save as excel 97-2003 template(.xlt) save as template and give your user this template... |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Error: "The function you are attempting to run contains macros" | Fadi | Word | 1 | 11-01-2011 05:25 AM |
Macro VBA "Save as" with bookmarks in file name string | Dom37 | Word VBA | 2 | 10-31-2011 03:28 AM |
Mailing: how to make the "page number" in Word is the same as "row number" in excel w | Jamal NUMAN | Word | 1 | 09-03-2011 11:37 AM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
"Microsoft Excel Application" missing in the "Component Services" on win08 | sword.fish | Excel | 0 | 02-26-2010 02:09 PM |