Email Spreadsheet

[mcartwri]

When a user closes the spreadsheet, it needs to save and automatically email to a certain recipient based on what they location they selected in a combo box that is in the spreadsheet.

 

[Juan Pablo González]

Your doubt is how to run that code when the user closes the book ? or how to save ? or how to email the workbook ?

First.
Use the Workbook_BeforeClose event.

Two.
ThisWorkbook.Save

Three.
Depends on what mail system you're using.