View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
E.J. van Wijngaarden E.J. van Wijngaarden is offline
external usenet poster
 
Posts: 3
Default 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