ExcelBanter - workbook tabs

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - workbook tabs (https://www.excelbanter.com/excel-discussion-misc-queries/170520-workbook-tabs.html)

I need to email only one tab from a workbook with multiple tabs...can you help?
--
Thanks, Kathy

right click on the tab name - click on Move or Copy - select the tab as your
needs - check the box Create a copy and on the drop down button select new
book, save the new book and email.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo

"Kathy" escreveu:

I need to email only one tab from a workbook with multiple tabs...can you help?
--
Thanks, Kathy

Have a look here

Mike

"Kathy" wrote:

I need to email only one tab from a workbook with multiple tabs...can you help?
--
Thanks, Kathy

It would help if I included the link

http://www.rondebruin.nl/sendmail.htm

Mike

"Kathy" wrote:

I need to email only one tab from a workbook with multiple tabs...can you help?
--
Thanks, Kathy

Kathy,

I am rearranging the steps shown by Marcelo.
1. Right click on the worksheet tab you intend to email.
2. Select "move or copy"
3. In the window, from the drop down list select "New Book".
4. Then Check the "Create a Copy" check box.

By doing this the exist sheet will not be separated but a new workbook with
the specified sheet will be generated as book 1 and the original workbook
would be intact.

You can then email the entire work book as an attachment.
--
Thanks
Suleman Peerzade

"Marcelo" wrote:

right click on the tab name - click on Move or Copy - select the tab as your
needs - check the box Create a copy and on the drop down button select new
book, save the new book and email.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo

"Kathy" escreveu:

I need to email only one tab from a workbook with multiple tabs...can you help?
--
Thanks, Kathy

As you had started a new thread, I did not see you had already received this
suggestion from earlier postings.

--

Regards
Roger Govier

"Mike H" wrote in message
...
It would help if I included the link

http://www.rondebruin.nl/sendmail.htm

Mike

"Kathy" wrote:

I need to email only one tab from a workbook with multiple tabs...can you
help?
--
Thanks, Kathy