Workbook.ShowConflictHistory Property

  • Article
Excel Developer Reference

True if the Conflict History worksheet is visible in the workbook that's open as a shared list. Read/write Boolean.

Syntax

expression.ShowConflictHistory

expression   A variable that represents a Workbook object.

Remarks

If the specified workbook isn't open as a shared list, this property fails. To determine whether a workbook is open as a shared list, use the MultiUserEditing property.

Example

This example determines whether the active workbook is open as a shared list. If it is, the example displays the Conflict History worksheet.

Visual Basic for Applications 
  If ActiveWorkbook.MultiUserEditing Then
    ActiveWorkbook.ShowConflictHistory = True
End If

See Also