6,210
社区成员
发帖
与我相关
我的任务
分享
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If ActiveSheet.Index <> 1 Then
If Target.Row >= 3 And Target.Row < 100 And _
Target.Column >= 4 And Target.Column <= 6 Then
Application.EnableEvents = False
Worksheets(1).Cells(Sh.Index, Target.Column - 2) = Now()
Application.EnableEvents = True
End If
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Set r1 = Range("D5")
If Application.Intersect(r1, Target) Is Nothing Then
Exit Sub
Else: Sheets("Sheet1").Cells(2, 2) = Time
End If
End Sub