Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Location
    Los Angeles, California, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    E-Mail Worksheet Only (XP)

    I was just wondering if it is possible to e-mail one worksheet and not the ten or so worksheets. I have been cutting and pasting or hiding sheets but was wondering if there is an easier way.

    thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: E-Mail Worksheet Only (XP)

    See http://www.rondebruin.nl/sendmail.htm (thanks to <!profile=sdckapr>sdckapr<!/profile> for mentioning this useful site.)

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: E-Mail Worksheet Only (XP)

    If you are asking how to do this without using VBA Code, then:<UL><LI>Make sure that your workbook is not maximised in Excel.<LI>Put your cursor inside the name area at the bottom of the target worksheet. <LI>Pressing down Ctrl AND your left mouse button at the same time, drag towards a blank area outside the workbook - but inside Excel. (You should see a tiny worksheet with a plus sign in it.)<LI>Release Ctrl and the mouse.<LI>Choose File|Send to|Mail Recipient (as attachment)[/list]HTH
    Gre

  4. #4
    New Lounger
    Join Date
    Feb 2003
    Location
    Los Angeles, California, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: E-Mail Worksheet Only (XP)

    Thanks Hans this site is great.

    Lance

  5. #5
    New Lounger
    Join Date
    Feb 2003
    Location
    Los Angeles, California, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: E-Mail Worksheet Only (XP)

    This works great.

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •