message box to print or email when closing workbook
 

I have an excel workbook set up with a marco that removes the save prompt
when closing. I want to add a message box that prompts to print or email when
closing. Is this possible?
The workbook is order forms for customers and is never saved, so they dont
have to remove old info every time they need to order