"Bob Phillips" wrote in message
...
Not directly. You could loop round and delete all the others except, and
the
SaveAs.

Activesheet.copy would appear a pretty direct means of generating a new
workbook containing (only) the desired sheet.

---
Regards
Norman