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