This might be a backwards way to do it, but it has been effective for
me:

highlight all desired sheets - right click on one of the sheets - move
or copy -
under- 'to book': select (new book) and then MAKE SURE you click the
check box 'create a copy'.

This will copy all the desired sheets into a new workbook, which you
can then send to your recipient, and promptly delete if you so desire.

Hope that helps

-Scott


--
darkwood
------------------------------------------------------------------------
darkwood's Profile: http://www.excelforum.com/member.php...o&userid=29948
View this thread: http://www.excelforum.com/showthread...hreadid=496468