Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    E-Mail Certain Worksheets in a Workbook

    Is there any way to, via code, e-mail certain, but not all, worksheets in sa workbook, upon prompting by Excel of which ones?
    Thanks in advance.

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts
    Hi

    Yes, there is a way.
    But it would help if you provided more info on what exactly you are trying to do.
    For example, why not delete the sheets you DON'T want to send, and then just send the remaining workbook?
    What if some sheets are protected?
    What if there are hidden sheets?
    What if there are formulas referencing sheets that you DON'T want to send?

    zeddy

Posting Permissions

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