Share via


ListDataFormat.ReadOnly Property

Excel Developer Reference

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.

Visual Basic for Applications
   
   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

See Also