Take a look he

http://www.mcgimpsey.com/excel/timestamp.html


In article ,
DKY wrote:


Is there a way to make it so that its "if the value of the cell changes"
not "if its double clicked"??

Also, I would like to protect and hide those cells in the worksheet and
not allow the users to edit or even see those date/times. Problem is
when I protect the cells and they enter the data in cell a1 or
whatever, it doesnt change the date/time cause well.... they're not
allowed to change it so it doesn't do the change.