Workbook.ConnectionsDisabled Property (Excel)
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.
Private Sub Workbook_Open()
ThisWorkbook.ConnectionsDisabled
End Sub