File...Send To...Email Recipient

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?
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
B

Bill Oertell

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.
 
Top