"Before Send" msgbox

[babycody]

Is there a piece of code that would allow a message box to pop up before a workbook is sent as an attachment? I have code in this workbook that updates a pivot table before a workbook is saved, but it does not update the pivot table if someone just sends the workbook as an attachment.