LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default File...Send To...Email Recipient

Is there any way to stop this? I have a workbook I've been working on (some of
you have helped me with it) that uses Workbook_BeforeSave to intercept a save
event. The sub then checks to see if certain required fields are populated.
However, it was brought to my attention that if a user clicked on File...Send
To...Mail Recipient, they could send the file without it going through the
checker.

The best solution would be for the File...Send To... to trigger an event that
simply runs the Workbook_BeforeSave sub. Alternatively, just disabling that
menu option would work, too.

Any ideas?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Sending file using File/Send to/Mail Recipient Dawn Excel Discussion (Misc queries) 0 March 21st 10 09:24 PM
Excel - Sending file using File/Send to/Mail Recipient Dawn Excel Discussion (Misc queries) 0 March 21st 10 09:20 PM
send excel sheet to email recipient as hyperlink Cyndi Excel Discussion (Misc queries) 2 May 20th 09 02:15 PM
Send To Email recipient one sheet from workbook Doug Excel Discussion (Misc queries) 1 October 3rd 08 05:38 PM
How can I send an excel workbook by email for recipient to update? Melanie Excel Discussion (Misc queries) 3 February 6th 06 02:37 AM


All times are GMT +1. The time now is 07:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"