+ Reply to Thread
Results 1 to 3 of 3

List of all users who are sharing a workbook

  1. #1
    Registered User
    Join Date
    07-12-2008
    Location
    DFW area, TX
    Posts
    7

    List of all users who are sharing a workbook

    Hi,

    I am building an Excel database that will be shared among multiple users, and I need a way to capture a list of all of the users who are sharing the workbook at any given instant.

    There must be a way to collect that information, because when I say Tools -> Share Workbook, it displays a list of all of the users who are currently sharing the workbook. How do I capture that information at any particular instant?

    Access to this user list is critical to my method of maintaining the security of the data in the workbook.

    I've done as thorough a search effort as I know how to do, and I keep coming up empty.

    Thanks for any help.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    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.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

  3. #3
    Registered User
    Join Date
    07-12-2008
    Location
    DFW area, TX
    Posts
    7
    Many thanks, Leith!

    I'm just a beginner VB programmer (although a rather seasoned BASIC programmer from the olden days), so I don't even know what many of the features/capabilities of VB are, and wasn't sure where to begin my research into a solution to my specific problem.

    I'm at home right now so I'm not in a position to test the results of that code in a multi-user environment, but it does appear to work at least as far as showing a single-line result (user - myself) here at home, and I've already modified it to write the userlist to a permanent sheet in my workbook.

    Thanks again, Leith, this appears to be exactly what I was needing!

    Mark

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1