Workbook.ConnectionsDisabled Property

  • Article
Excel Developer Reference

Disables the external connections or links in the workbook. Read-only

Version Information
 Version Added:  Excel 2007

Syntax

expression.ConnectionsDisabled

expression   A variable that represents a Workbook object.

Return Value
Boolean

Example
Disables the external link when the workbook is opened.

Visual Basic for Applications 
  Private Sub Workbook_Open()
    ThisWorkbook.ConnectionsDisabled
End Sub

See Also