I was hoping for another route

Manual you can select the tabs and right click on it and choose "Move or Copy"

You can copy the sheets in a new workbook this way and send that workbook
This is very easy with the add-in

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DrWilki" wrote in message ...
Thanks for the replies. I was hoping for another route, but did feel this
was probably the only option.

Dale

"Ron de Bruin" wrote:

If the OP want to use code he can also use this macro
http://www.rondebruin.nl/mail/folder1/mail3.htm


See the note below the macro
*************************
You can also use the this line if you want to send the selected sheets.
ActiveWindow.SelectedSheets.Copy





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"David McRitchie" wrote in message ...
Hi "DrWilki", posted in excel.misc
Create a macro to copy the entire workbook,
delete the worksheets you don't want, then save the new
workbook, and to send it to email recipient.

Take a look at Ron's addin
http://www.rondebruin.nl/mail/add-in.htm
not clear to me if selection means selection of cells,
or selection of worksheets, but I think it would be
worksheets as it is workbooks that are being emailed..

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"DrWilki" wrote in message
...
I created a 15-tab spreadsheet. Most of the tabs interact in some fashion.

I want to email certain tabs without the others attached. Is this
possible?