Well lots of ways to do that but an easy one to conceptualise ( and
fairly fool proof) with a simple spreadsheet.

On opening the workbook make a copy of the sheet and hide it. On
closing the workbook run down each line comparing the current value
with the corresponding value on the saved sheet, update the last
changed date as appropriate.

Gets sort of complicated if you change rows around and that sort of
thing then you need to use the cell change event. But these are usually
problematic for a beginner to debug.


Just to get you thinking.


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=544696