Automatic time/date stamp for last time worksheet was changed

[excelmyexcel]

Hi,

I am trying to have Excel automatically put a time/date stamp in a cell anytime a worksheet (not a workbook) has been changed.

I have seen the code for an automatic time/date stamp right before a workbook is saved, but I am looking for something that will do this anytime a worksheet is changed.

Any tips are appreciated.

Thanks!

 

[VoG]

Right click the Excel logo just to the left of File on the menu bar, select View Code and paste in

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Application.EnableEvents = False
Sh.Range("A1").Value = Now
Application.EnableEvents = True
End Sub

Everytime there is a change on any sheet a timestamp will appear in A1 of that sheet.

 

[excelmyexcel]

Thanks, VoG II. That worked great!

 

[foxyroxy6062]

Hi VoG,

I have a 9-worksheet workbook. I want each of 8 cells (b11-b18) to return the last update date & time for each of the other 8 worksheets. Is this possible?

Thanks in advance for the help