modified time of a worksheet
 

Is it possible to find out when a worksheet has been
modified within a multiple worksheet excel workbook?

modified time of a worksheet
 

The only way I can think of is to use the Worksheet_Change event

Private Sub Worksheet_Change(ByVal Target As Range)
'to store the time in a worksheet.names("ChangeDate")
Me.Names.Add "ChangeDate", Now()
'or
'to write to a catalog sheet using a range for each worksheet name.
Worksheets("Catalog").Range(Me.Name) = Now()
End Sub

It kind of depends upon where you want the information stored.

Stephen Rasey
Houston
http://wiserways.com
http://excelsig.org


"Gary Adamson" wrote in message
...
Is it possible to find out when a worksheet has been
modified within a multiple worksheet excel workbook?