Sync Event
This documentation is archived and is not being maintained.

Workbook.Sync Event

Office 2007
Occurs when the local copy of a worksheet that is part of a Document Workspace is synchronized with the copy on the server.



expression   An expression that returns a Workbook object.


NameRequired/OptionalData TypeDescription
SyncEventTypeRequiredMsoSyncEventTypeThe status of the worksheet synchronization.


The following example displays a message if the synchronization of a worksheet in a Document Workspace fails.

Visual Basic for Applications
Private Sub Worksheet_Sync(ByVal SyncEventType As Office.MsoSyncEventType)

    If SyncEventType = msoSyncEventDownloadFailed Or _
            SyncEventType = msoSyncEventUploadFailed Then
        MsgBox "Document synchronization failed.  " & _
            "Please contact your administrator " & vbCrLf & _
            "or try again later."
    End If
End Sub

© 2016 Microsoft