How do I set up a date to update individually on each worksheet?
 

I need the date on each worksheet in a workbook to update as the worksheet is
updated. Currently, if I update one worksheet the date on all of the sheets
in the book will update.

How do I set up a date to update individually on each worksheet?
 

I assume that you are updating a Cell on the sheet somewhere??? If so then
you could use code something like this. The code is placed in the
ThisWorkbook module (right click the Excel logo next to File on the Excel
menu and select View Code). If you want it in the Footer or somewhere else
you will have to let us know...

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Sh.Range("A1").Value = Now() 'Add timestamp to cell A1 on active sheet
End Sub


--
HTH...

Jim Thomlinson


"chefbeavrdee" wrote:

I need the date on each worksheet in a workbook to update as the worksheet is
updated. Currently, if I update one worksheet the date on all of the sheets
in the book will update.