SharedWorkspace.Members Property (Office)

Gets a SharedWorkspaceMembers collection that represents the list of members in the current shared workspace. Read-only.


Beginning with Microsoft Office 2010, this object or member has been deprecated and should not be used.


expression. Members

expression A variable that represents a SharedWorkspace object.


The following example lists the members in the current shared workspace.

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 

See also

SharedWorkspace Object

SharedWorkspace Object Members