[sanlee]

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

[NeedToKnow]

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

[Andrew Ball[_2_]]

I fyou haven't got too many unwanted worksheets, it imght be easiet to just
delete them, send the workbook as it is, then close the workbook WITHOUT
SAVING so that next time you open it the missing sheets are still there.

Andrew


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

[sanlee]

good suggestion - I'm trying a test now

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

[sanlee]

I might try that if I can't do it any other way - I add a new worksheet every
day which is what I'm trying to email, not the previous days' worksheets.
I'm testing now the theory of copying one worksheet to new blank workbook and
emailing - I can try your method too by copying workbook to workbook and
deleting the previous days' worksheets in the new workbook without losing the
original workbook.

"Andrew Ball" wrote:

I fyou haven't got too many unwanted worksheets, it imght be easiet to just
delete them, send the workbook as it is, then close the workbook WITHOUT
SAVING so that next time you open it the missing sheets are still there.

Andrew


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

[sanlee]

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

[sanlee]

The test emailed to myself worked: I highlighted the worksheet (click upper
left corner box), right click worksheet, copy, create new workbook, paste,
and email; then closed the newly created worksheet without naming or saving.
Thanks for your help.

"Andrew Ball" wrote:

I fyou haven't got too many unwanted worksheets, it imght be easiet to just
delete them, send the workbook as it is, then close the workbook WITHOUT
SAVING so that next time you open it the missing sheets are still there.

Andrew


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

[sanlee]

Uh oh - back to the drawing board - I was able to send the single worksheet,
but it does not carry the formatting, so columns, etc., were all out of whack
and it would take me too much work to recreate the original formatting in the
new workbook for emailing worksheet daily. So, Any other suggestions?

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

[NeedToKnow]

When you have copied sheet to new book, you can go back to old, copy all, go
to new, paste special - formats. In 2003 version formats stay. Hope this
helps1

"sanlee" kirjoitti:

Uh oh - back to the drawing board - I was able to send the single worksheet,
but it does not carry the formatting, so columns, etc., were all out of whack
and it would take me too much work to recreate the original formatting in the
new workbook for emailing worksheet daily. So, Any other suggestions?

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

[sanlee]

I just tried, and everything iappears to be right, except the columns are all
reverted back to same width each instead of the way I changed them to
different widths. Next???? You've been very helpful and I hesitate to keep
asking, but if you do come up with anything, please email me at
. Thanks.

"NeedToKnow" wrote:

When you have copied sheet to new book, you can go back to old, copy all, go
to new, paste special - formats. In 2003 version formats stay. Hope this
helps1

"sanlee" kirjoitti:

Uh oh - back to the drawing board - I was able to send the single worksheet,
but it does not carry the formatting, so columns, etc., were all out of whack
and it would take me too much work to recreate the original formatting in the
new workbook for emailing worksheet daily. So, Any other suggestions?

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

[NeedToKnow]

You can go again back to old- select all - copy - to new book - paste
special - column widths

"sanlee" kirjoitti:

I just tried, and everything iappears to be right, except the columns are all
reverted back to same width each instead of the way I changed them to
different widths. Next???? You've been very helpful and I hesitate to keep
asking, but if you do come up with anything, please email me at
. Thanks.

"NeedToKnow" wrote:

When you have copied sheet to new book, you can go back to old, copy all, go
to new, paste special - formats. In 2003 version formats stay. Hope this
helps1

"sanlee" kirjoitti:

Uh oh - back to the drawing board - I was able to send the single worksheet,
but it does not carry the formatting, so columns, etc., were all out of whack
and it would take me too much work to recreate the original formatting in the
new workbook for emailing worksheet daily. So, Any other suggestions?

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

[Gord Dibben]

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