saving single worksheet
Thanks for both answers.
I changed the code to:
Sub SaveTestSheetSeparately()
Application.ScreenUpdating = False
Worksheets("test").Copy
ActiveWorkbook.SaveAs "test1.xls"
ActiveWorkbook.Close
Application.ScreenUpdating = True
End Sub
Now it does exactly what I want.
Ed
|