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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
