save single excel worksheet out of workbook in excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have a multiple worksheet file and I'm trying to save just a single
worksheet. Just upgraded to excel 2007 and this is no longer an option in
the "save as" options. Any suggestions?
 
Right click on the sheet tab and choose "Move or Copy"

To Book: new book
Then check the "create a copy" checkbox

You can save this file now

With code it is one line of code to create a new file with the sheet
If you need help with that post back
 
Saving a single worksheet was never an option in any version.

You have to copy that sheet to anew book and save that.


Gord Dibben MS Excel MVP
 
Back
Top