| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email selected tabs of spreadsheet?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Email selected tabs of spreadsheet?
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Email selected tabs of spreadsheet?
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Email selected tabs of spreadsheet?
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Email selected tabs of spreadsheet?
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy selected tabs from multiple workbooks to a new workbook | Excel Worksheet Functions | |||
| how do I change the colour of selected auto filter tabs | Excel Worksheet Functions | |||
| Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
| Email selected worksheets from a workbook as attachment. | Excel Worksheet Functions | |||
| attaching tabs to email | Excel Discussion (Misc queries) | |||
Hybrid Mode
