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 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