File...Send To...Email Recipient

  • Thread starter Thread starter Bill Oertell
  • Start date Start date
B

Bill Oertell

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?
 
Hi Bill!

Re:

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.

Then someone would install Ron de Bruin's SendMail Addin!!

Happy New Year
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
I agree that having File...Send To trigger an event would be ideal, but I have
no idea how to accomplish that. I've looked at all the events that VB can
detect, and I don't see anything that looks like what I want.
 
Back
Top