workbook tabs

M

Marcelo

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:
 
S

Suleman Peerzade

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

Roger Govier

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