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?

You need a macro triggered by the Workbook_close event.

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

The code needs to throw up a dialog box

Application.inputbox(....)

and then a Thisworkbook.save


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=560668