Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
modified time of a worksheet
Is it possible to find out when a worksheet has been
modified within a multiple worksheet excel workbook? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date/Time When content of a Worksheet is Modified | Excel Worksheet Functions | |||
Modified IF formula for military time | Excel Worksheet Functions | |||
Updating Time when a field has been modified | Excel Worksheet Functions | |||
Time Date Last Modified | Excel Discussion (Misc queries) | |||
Copy Modified Worksheet 1 Data to Worksheet 2 | Excel Programming |