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

  • Thread starter Thread starter Ronald van Zantvoort
  • Start date Start date
R

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
 
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
 
Back
Top