What version of Excel ar you using? I have tested the code in Excel 2002 and
Excel 2007 and it does not overwrite the Master sheet.

I wonder if somehow the Master worksheet is remaining selected along with
the copy of the new worksheet that is created. If that occurs then both
sheets get updated. Check the worksheet tabs and ensure that only the most
recent sheet is selected.

If this is occurring then insert the following line as the last line of the
code after the line "ActiveSheet.Name = strNewShtName".

Sheets(strNewShtName).Select

--
Regards,

OssieMac


"oldjay" wrote:

The latest code you gave me does overwrite the Master sheet. Everything else
is OK

"OssieMac" wrote:

I am not sure what you are doing. The code you first posted will always copy
the Master sheet. The code I have given you will always copy the active sheet
and the Master sheet is not overwritten.

I have assumed that what you want to do is:-

Start with the Master sheet and you make a copy of it.

You then amend the copy and make another new copy.

You then amend the newest copy and make another copy and continue this way.

Is my assumption correct?

--
Regards,

OssieMac