How about trying the Free download "ASAP Utilities"?
You can highlight any (one/two/group) sheets - OR ranges of cells on one
work tab - from within one workbook and with ASAP you simply one-click &
create a new workbook (i.e. with JUST those items that you want copied).
Then send THAT version.
Works for me!
--
mac
"widman" wrote:
I use something similar to sent out quotes from a workbook that has costs and
other details. I simple macro copies the sheet, pastes it as values, deletes
the sheet with details, saves it, and emails it as an attachment.
"darkwood" wrote:
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