How about copying the new sheet to one with the permanent sheetname.

You can probably record a macro using edit, move or copy sheet, copy sheet.

Sub Macro14()
On Error Resume Next
Sheets("permanent sheet").Delete
On Error GoTo 0
' ---Sheets("Summary").Copy befo=Sheets(1)
ActiveSheet.Copy befo=Sheets(1)
ActiveSheet.Name = "Permanent sheet"
ActiveWorkbook.Save
End Sub







--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Homer" wrote in message ...
Changing data file location in Word is easy, just browse in a GUI environment.

Changing data file locations in Word is like being in the "dark" ages.
We must KEY the full path name. (or may be able to paste).

Excel needs a GUI BROWSE option to enter default file location. . .

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...ic.excel.setup