+ Reply to Thread
Results 1 to 5 of 5

Macro to stop workbook from being emailed

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Waterbury, CT
    MS-Off Ver
    Office 365
    Posts
    1,175

    Macro to stop workbook from being emailed

    Hi.
    I this main workbook which i'm always afraid of it being accidentally emailed and sent to the wrong hands.

    Is it possible that when the send button is hit a macro will run which will stop the workbook from being sent via email?

    
    Sub Macro1()
    
        Application.Dialogs(xlDialogSendMail).Show
    'code to block from sending via email
    
    End Sub

  2. #2
    Forum Contributor
    Join Date
    04-24-2007
    Location
    NYC
    MS-Off Ver
    2k3/2k7/2010
    Posts
    270

    Re: Macro to stop workbook from being emailed

    If you use outlook you can write a macro to check on the attachment filename before sending.

  3. #3
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Waterbury, CT
    MS-Off Ver
    Office 365
    Posts
    1,175

    Re: Macro to stop workbook from being emailed

    Is there a way that excel can stop the workbook from even being shown as an attachment to the email to begin with?
    Meaning, that outlook won't even get the chance to show the email with the attached file?

  4. #4
    Forum Contributor
    Join Date
    04-24-2007
    Location
    NYC
    MS-Off Ver
    2k3/2k7/2010
    Posts
    270

    Re: Macro to stop workbook from being emailed

    You are asking excel to do something it was not built for. If what you want to do is on Email then you need to work on the application that handles Email.

  5. #5
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Waterbury, CT
    MS-Off Ver
    Office 365
    Posts
    1,175

    Re: Macro to stop workbook from being emailed

    I hear.
    K, thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Disable workbook from being printed or emailed
    By kosherboy in forum Excel General
    Replies: 5
    Last Post: 12-31-2013, 03:49 PM
  2. Can parts of a workbook be emailed selectively
    By Bachi in forum Excel General
    Replies: 0
    Last Post: 04-13-2011, 05:09 PM
  3. stop spreadsheet from being emailed
    By Jordans121 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2010, 09:01 PM
  4. Hyperlinks fail when workbook is emailed
    By Tony Vargo in forum Excel General
    Replies: 7
    Last Post: 10-02-2009, 07:01 AM
  5. [SOLVED] Password protect a workbook created and emailed by a macro?
    By isewdollies in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2006, 03:50 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1