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!



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

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Bill Oertell" wrote in message
...
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?

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.

"Norman Harker" wrote in message
...
Hi Bill!



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

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Bill Oertell" wrote in message
...
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?