ListDataFormat.ReadOnly Property (Excel)
Returns True if the object has been opened as read-only. Read-only Boolean.
Syntax
expression .ReadOnly
expression A variable that represents a ListDataFormat object.
Remarks
This property is used only for tables that are linked to a SharePoint site.
Example
The following example displays the setting of the ReadOnly property for the third column of a table in Sheet1 of the active workbook.
Dim wrksht As Worksheet
Dim objListCol As ListColumn
Set wrksht = ActiveWorkbook.Worksheets("Sheet1")
Set objListCol = wrksht.ListObjects(1).ListColumns(3)
Debug.Print objListCol.ListDataFormat.ReadOnly