Tracking Users - Excel 2013

[mgeiss]

Hello,</SPAN>

I was hoping you all could help me. I have a workbook and I need to know who is opening it. I would like to know the username and possible the date, but the date is not crucial. I’m very familiar with excel, but don’t know VBA at all. Could someone walk me through creating a way to track users?</SPAN>

Any help is appreciated!</SPAN>

 

[ChrisBM]

While I have never tried to do this, a possible way to do this would be to capture the username in a hidden sheet (which I have called "Opened By") when they open the workbook. To do this we use the Workbook_Open command as below.

To set this up
Insert new sheet titled 'Opened By'
Add "Name" to cell A1
Add "Time" to cell B1
(Add "Test" to cells A2 and B2) - otherwise macro will crash :P
Add the vba code below

Please let me know if you need any help with this.

Private Sub Workbook_Open()

    Sheets("Opened By").Range("A1").End(xlDown).Offset(1, 0).Value = Application.UserName
    Sheets("Opened By").Range("A1").End(xlDown).Offset(1, 1).Value = Now()

    ThisWorkbook.Save

End Sub

 

[mgeiss]

You did it, you did it!! Thank you so much! you're a life safer!

-Marina

 

[mgeiss]

I do have one question. Is it possible for this to work without the users enabling macros?