Email selected tabs of spreadsheet?

[Guest]

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?

 

[David McRitchie]

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..

 

[Ron de Bruin]

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

 

[Guest]

Thanks for the replies. I was hoping for another route, but did feel this
was probably the only option.

Dale

 

[Ron de Bruin]

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