Change werkt niet in thisworkbook.
Van >>>>>>>>>>>>> Naar
User Name Logname Wijziging Tabblad & Cel Van Naar Datum Tijd
Van >>>>>>>>>>>>> Naar
User Name Logname Wijziging Tabblad & Cel Van Naar Datum Tijd
Code:
Private Sub Workbook_sheetChange(ByVal Sh As Object, ByVal target As Range)
Dim PreviousValue
Application.EnableEvents = False
If target.Count > 1 Then
Application.Undo
Application.EnableEvents = True
Exit Sub
End If
If target.Value <> PreviousValue Then
x = Environ("USERNAME") & "|" & Application.UserName & "|" & " changed cell " & "|" & ActiveSheet.Name & target.Address _
& "|" & PreviousValue & "|" & target.Value & "|" & Date & "|" & Time
Sheets("log").Cells(65000, 1).End(xlUp).Offset(1, 0).Resize(1, 8).Value = Split(x, "|")
End If
Application.EnableEvents = True
End Sub
Private Sub Worksheet_SelectionChange(ByVal target As Range)
PreviousValue = target.Value
End Sub