save single excel worksheet out of workbook in excel 2007

R

rokbroscore

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?
 
R

Ron de Bruin

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
 
G

Gord Dibben

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
 
Top