Applies To
Workbook Object.
Description
Returns a one-based, two-dimensional array specifying information about each user who has the workbook open as a shared list. The first element of the second dimension is the name of the user; the second element is the date and time when the user opened the workbook; and the third element is a number indicating the type of list (1 indicates exclusive, and 2 indicates shared). This property is available only in Microsoft Excel for Windows 95. Read-only.
Remarks
The UserStatus property doesn't return information about users who have the specified workbook open as read-only.
See Also
MultiUserEditing Property, SaveAs Method.
Example
This example creates a new workbook and inserts information about all users who have the active workbook open as a shared list.
users = ActiveWorkbook.UserStatus
With Workbooks.Add.Sheets(1)
For row = 1 To ubound(users, 1)
.Cells(row, 1) = users(row, 1)
.Cells(row, 2) = users(row, 2)
Select Case users(row, 3)
Case 1
.Cells(row, 3).Value = "Exclusive"
Case 2
.Cells(row, 3).Value = "Shared"
End Select
Next
End With