How can I determine the person who is currently working in the spreadsheet
I'd like to generate a "Last Change when/who" entry in a spreadsheet. I was successful with time/date but I have no clues how to find out who is the person who was doing the change.
- Private Sub Worksheet_Change(ByVal Target As Range)
- Application.EnableEvents = false
- On Error Goto ENEV
- range("LastChangeDateTime").Value=Now ' <- this works perfect
- range("LastChangePerson").Value=???? ' <- what should I enter here?
- ENEV:
- Application.EnableEvents = true
- End Sub