Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-04-2011, 06:32 PM
KIM SOLIS KIM SOLIS is offline How to "deactivate" the Excel's SAVE function Windows XP How to "deactivate" the Excel's SAVE function Office 97
Novice
How to "deactivate" the Excel's SAVE function
 
Join Date: Sep 2011
Posts: 29
KIM SOLIS is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 11-05-2011, 01:57 AM
Catalin.B Catalin.B is offline How to "deactivate" the Excel's SAVE function Windows Vista How to "deactivate" the Excel's SAVE function Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

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...
Reply With Quote
Reply

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
How to "deactivate" the Excel's SAVE function Macro VBA "Save as" with bookmarks in file name string Dom37 Word VBA 2 10-31-2011 03:28 AM
How to "deactivate" the Excel's SAVE function 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 "deactivate" the Excel's SAVE function 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft