Syntax

expression.Sync

expression An expression that returns a Workbook object.

Return Value
Sync

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.

Visual Basic for Applications 
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
Sync sync property

See also: