title | keywords | f1_keywords | ms.prod | api_name | ms.assetid | ms.date | ||
---|---|---|---|---|---|---|---|---|
SharedWorkspace.Tasks Property (Office) |
vbaof11.chm276003 |
|
office |
|
9f7fa28d-f442-cbec-de7c-9109cc3e6f2e |
06/08/2017 |
Gets a SharedWorkspaceTasks collection that represents the list of tasks in the current shared workspace. Read-only.
Note Beginning with Microsoft Office 2010, this object or member has been deprecated and should not be used.
expression. Tasks
expression A variable that represents a SharedWorkspace object.
The following example lists the tasks in the current shared workspace.
Dim swsTasks As Office.SharedWorkspaceTasks
Set swsTasks = ActiveWorkbook.SharedWorkspace.Tasks
MsgBox "There are " & swsTasks.Count & _
" task(s) in the current shared workspace.", _
vbInformation + vbOKOnly, _
"Collection Information"
Set swsTasks = Nothing