You need to go into the vba editor alt F11

goto the thisworkbook object in the project explorer, then choos
Workbook and the BeforeClose event

then you want the msgbox function or you could even just update th
cell automatically.

Hope this points you in the right direction.

Cheer

--
tony
-----------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=54469

Thanks all.

I used the Before Save option in the end and wrote a suitably snotty
message. ha ha!

To automatically update the cells with the date would be great, but as
theres a 'Last Updated' cell on each line of a 500 line document and not
every line gets updated this wouldn't be applicable. A great idea for another
document though!