I would guess you could use the "save as" option under the file menu. Most programs have an option like that.

Go to File and choose "Save As" and rename the file. You can put it in a different directory, too. To save your spreadhseet as a template, go to File > Save as > and Save as type (the text box below the file name text box) "Template". That saves the file with an xlt extension. Normal worksheets have an xls file extension. Make sure you designate the file as "Read-only" by going to File >> Properties and checking the read-only checkbox.

Into the spreadsheet template itself, put a "save" cell that just displays the word "SAVE" ... A1 is the best place, top left corner ... then format the cell for a formula, so when it is highlighted and the user presses "enter" it launches the macro program ... set it so it places the file in your chosen directory, so as to make sure it does not get lost, and set it so it names the file "Get time and date" ... so the name of your saved file will be what ever minute, hour, and day the file is saved. ... it also helps if the template is read only, there is a backup copy of the template, the template is blank and gets the data from a second file, and you write a macro program that is launched as soon as the template file is opened ... and this macro program opens a new file in the template's format, gets the data, loads the data into the new file, then automatically closes the first template file, leaving only the second file open, and it is the new file already.

In windows explorer, right click on the file. Select the "Read Only" property. That way the file cannot be written over, and Excel always will ask to save as.

Sub SaveSheetAs() ' ' SaveSheetAs Macro ' Macro written 05/02/2008 by Dirk ' ' ' store current workbook and worksheet name currWB = ActiveWorkbook.Name ' the path to the file currWBP = ActiveWorkbook.Path ' the full path and name currWBFN = ActiveWorkbook.FullName ' the active worksheet name currWS = ActiveSheet.Name currRow = ActiveCell.Row currCol = ActiveCell.Column ' add a new workbook Workbooks.Add ' remember it's name newWB = ActiveWorkbook.Name ' go back to original workbook Windows(currWB).Activate ' select and copy all cells on current worksheet Cells.Select Selection.Copy ' go back to the new workbook Windows(newWB).Activate ' paste the original date into the new worksheet Cells.Select ActiveSheet.Paste Range("A1").Select Application.CutCopyMode = False ' get a name to save the new workbook as tmpSA = Application.GetSaveAsFilename ' add the xls extention if needed If Right(tmpSA, 1) = "." Then tmpSA = tmpSA & "xls" End If ' save it ' you can change the read only recommended to True If tmpSA <> False And tmpSA <> "" Then ActiveWorkbook.SaveAs Filename:=tmpSA, FileFormat:=xlNormal, _ Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False End If ' tmpSA <> False And tmpSA <> "" ' close the new work book ' comment this line out 'if you don't want to close it ActiveWorkbook.Close ' select the original cell Cells(currRow, currCol).Select End Sub

Yes,if you only want to save a specific worksheet into a new file perhaps this may work. 1. point your mouse to the tab of the worksheet you want to save and rigth click. 2. choose the menu move worksheet...(some kind'a like that) 3. click to new workbook 4. click the checkbox located at the lower left corner of the menu...(copy worksheet). 5. a new workbook will open with the worksheet alone you want...and now you can save it alone...hope it thus help...d:-)