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.

Syntax

expression.Sync(SyncEventType)

expression   An expression that returns a Workbook object.

Parameters

NameRequired/OptionalData TypeDescription
SyncEventTypeRequiredMsoSyncEventTypeThe status of the worksheet synchronization.

Example

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



Show:
© 2016 Microsoft