SharedWorkspaceMembers Collection

SharedWorkspace SharedWorkspaceMembers SharedWorkspaceMember

A collection of the SharedWorkspaceMember objects in the current shared workspace.

Using the SharedWorkspaceMembers Collection

Use the Members property of the SharedWorkspace object to return a SharedWorkspaceMembers collection.

    Dim swsMembers As Office.SharedWorkspaceMembers
    Set swsMembers = ActiveWorkbook.SharedWorkspace.Members
    MsgBox "There are " & swsMembers.Count & _
        " member(s) in the current shared workspace.", _
        vbInformation + vbOKOnly, _
        "Collection Information"
    Set swsMembers = Nothing

Properties | Application Property | Count Property | Creator Property | Item Property | ItemCountExceeded Property | Parent Property

Methods | Add Method

Parent Objects | SharedWorkspace

Child Objects | SharedWorkspaceMember Object