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
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
