changing date on sheet every time on save when only that particularsheet is changed (Excel 2000)

[Ronald van Zantvoort]

Hi all,

I would very much like a date on each of the sheets, which updates only
and every time that particular sheet is changed and the workbook is
saved.

I have found some usefull hints in this newsgroup regarding this,
however these apply to the workbook.

Besides, I am a total newbie on using macros in Excel :-(

If anybody could please offer any help / insight please?

Thank you all very much in advance

Ronald van Zantvoort

 

[Earl Kiosterud]

Ronald,

You may be able to simplify the task by having the date on each sheet
updated whenever any change is made. Then when it's saved, it's already
there.

Private Sub Worksheet_Change(ByVal Target As Range)
Range("A3") = Now()
End Sub

 

[Ronald van Zantvoort]

Works like a dream! Thanks!