Hello oldjackbob,
This is straight from the VBA help file...
UserStatus Property
Returns a 1-based, two-dimensional array that provides 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 last opened the workbook, and the third element is a number indicating the type of list (1 indicates exclusive, and 2 indicates shared). Read-only
This example creates a new workbook and inserts into it information about all users who have the active workbook open as a shared list.
Sincerely,
Leith Ross
Bookmarks