Excel shared file
Hi Gabriel;
Private Sub UsersList()
Dim users, msg As String, status As String
users = ThisWorkbook.UserStatus
For Row = 1 To UBound(users, 1)
msg = msg & users(Row, 1) & " " & Format(users(Row, 2), "dd/mm/yy h:mm")
& " "
If users(Row, 3) = 1 Then status = "(Exclusive mode)" Else status =
"(Shared mode)"
msg = msg & status & vbLf
Next
MsgBox msg, 64
End Sub
MP
"Gabriel" a écrit dans le message de
om...
Is there any way to getting a list (with the help of VBA) of who is
opening an excel shared file ?
Thank you
|