I would like to receive an email notification with a hyperlink to an excel workbook whenever someone completes said workbook (actually a customized template we use for each of our individual projects).
After a little digging, one approach seems to be to create a beforeclose event with a customized dialog box from which, if the user clicks yes, the email is automatically generated and sent (if NO is clicked, the workbook closes as usual). I'm starting out with VBA so I would appreciate any suggestions or help on the code required for such a n event or alternative ideas. Thank you in advance!!! gabonais@yahoo.com