OK, I did as you said<

You did not do as NeedToKnow said.

Re-read the reply.


Gord Dibben MS Excel MVP

On Wed, 18 Jun 2008 17:58:07 -0700, sanlee
wrote:

OK, I did as you said - highlighted the worksheet (click upper left corner),
right click worksheet, copy, create new workbook, paste, and email (to myself
for testing) - I received the one worksheet and just closed the new workbook
without naming or saving. I think this will work. Thanks for the help.

"NeedToKnow" wrote:

Would it work if you right-click sheet with mouse, select move or copy, tick
"make a copy" and then select To new workbook. Rename new workbook as wanted
and send that one?

"sanlee" kirjoitti:

I have Excel 2007 with Vista and want to email just a single worksheet, not
the entire workbook - How do I do that? Someone suggested I could do it thru
"Print", but that only prints the worksheet - I want to email it - I don't
see anything in "print" that would enable me to select "email".