View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stephen Rasey[_2_] Stephen Rasey[_2_] is offline
external usenet poster
 
Posts: 41
Default 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?