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