But that is still not directly

Bob

"srgggf" <jbkjkbjn wrote in message
...

"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