Hi guys,
I have a workbook in which I'd like to keep track of the last 10 users who modified my workbook.
I currently have the following code to extract the current user but cannot figure out how to modify it to achieve what I want:
Ideally, I'd like to have in O12 the username of the last user who modified the workbook and in P12 the date and time at which the change was made (or the file was closed, providing a change was made).
Then, in O13, the second last username, etc.
And ideally, have a macro linked to a button where I can erase the whole list of 10 and obviously enter my username back at the top of the list with the appropriate date.
Am I being completely unrealistic or can this be done?
Thanks in advance to whoever can help me
IM
I have a workbook in which I'd like to keep track of the last 10 users who modified my workbook.
I currently have the following code to extract the current user but cannot figure out how to modify it to achieve what I want:
Code:
Private Sub Workbook_Open()
sheet3.Range("O12").Value = Environ("username")
End Sub
Ideally, I'd like to have in O12 the username of the last user who modified the workbook and in P12 the date and time at which the change was made (or the file was closed, providing a change was made).
Then, in O13, the second last username, etc.
And ideally, have a macro linked to a button where I can erase the whole list of 10 and obviously enter my username back at the top of the list with the appropriate date.
Am I being completely unrealistic or can this be done?
Thanks in advance to whoever can help me

IM