SharedWorkspaceMembers Object - Microsoft Office Excel

Example

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

Visual Basic for Applications

Visual Basic for Applications
`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`

 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: