Workbook.Sync Event

Syntax

expression.Sync(SyncEventType)

expression An expression that returns a Workbook object.

Parameters

Name	Required/Optional	Data Type	Description
SyncEventType	Required	MsoSyncEventType	The 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

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`

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

Sync sync event

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

See also: