Save a single sheet from a workbook

J

JAMES T.

Is there a way to save a single sheet from a workbook instead of saving
the whole book.
 
J

Jason Morin

No. The best you can do is delete all the other sheets
and save the workbook under a new name.

HTH
Jason
Atlanta, GA
 
B

Bob Phillips

You can do it with VBA

Sub SaveThis()
Dim sFilename As String
Activesheet.Copy
sFilename = Application.GetSaveAsFilename( _
fileFilter:="Excel Files (*.xls), *.xls")
If sFilename <> False Then
ActiveWorkbook.SaveAs sFilename
End If

End Sub


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
J

JE McGimpsey

Sure. Choose Edit/Move or Copy Sheet and copy the sheet to a new
workbook. Save the workbook.
 
Top