Share via


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

See Also

Concepts

ListDataFormat Object

ListDataFormat Object Members