worksheets("Save Sheet").Copy ' copies to a new workbook
Activeworkbook.SaveAs "Save.xls"

--
Regards,
Tom Ogilvy

"Jay Wilson" wrote in message
...
How do I save only 1 sheet of a workbook into a new file

I tried
Worksheets("Save Sheet").Saveas Filename:="save.xls"

The above for some reason is saving all sheets and macros, not just the
one
I requested it save.

Thanks
---
Jay Wilson