How do I add an alert message upon a user closing the workbook?

E

ehoskins

I need users of the workbook to be alerted to enter a new amendment number,
date, and reason for amending before closing. How can I do that?
 
M

mrice

You need a macro triggered by the Workbook_close event.

Place the code on the ThisWorkbook tab of the VBS editor and selec
workbook in the box on the left and then close in the event box on th
right.

The code needs to throw up a dialog box

Application.inputbox(....)

and then a Thisworkbook.sav
 
Top