Sync Property
Returns a Sync object that provides access to the methods and properties for documents that are part of a Document Workspace.
expression.Sync
expression Required. An expression that returns a Workbook object.
Example
The following example displays the name of the last person to modify the active workbook if the active workbook is a shared document in a Document Workspace.
Dim eStatus As MsoSyncStatusType
Dim strLastUser As String
eStatus = ActiveDocument.Sync.Status
If eStatus = msoSyncStatusLatest Then
strLastUser = ActiveWorkbook.Sync.WorkspaceLastChangedBy
MsgBox "You have the most up-to-date copy." & _
"This file was last modified by " & strLastUser
End If