Save will save a workbook, not a worksheet.
It sounds as though you need to move your new worksheet into a new workbook
and save that.
If you want a copy of that added as an extra sheet to your original
workbook, close the original book without saving, then reopen and copy from
your new workbook into your old one.
--
David Biddulph