I found and am using code below to insert time stamp when edits are made in column W. This is working well but i was wondering how to include Username in the code. I have tried but I keep getting "Compile Error: Can't find project or library"
Code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If Not Intersect(Range("W9:W286"), .Cells) Is Nothing Then
Application.EnableEvents = False
If IsEmpty(.Value) Then
.Offset(0, 36).ClearContents
Else
With .Offset(0, 36)
.NumberFormat = "dd mmm yy"
.Value = Now
End With
End If
Application.EnableEvents = True
End If
End With
End Sub