Share via


QueryTable.EnableEditing Property

Excel Developer Reference

True if the user can edit the specified query table. False if the user can only refresh the query table. Read/write Boolean.

Syntax

expression.EnableEditing

expression   A variable that represents a QueryTable object.

Remarks

This example sets query table one so that the user cannot edit it.

If you import data using the user interface, data from a Web query or a text query is imported as a QueryTable object, while all other external data is imported as a ListObject object.

If you import data using the object model, data from a Web query or a text query must be imported as a QueryTable, while all other external data can be imported as either a ListObject or a QueryTable.

You can use the QueryTable property of the ListObject to access the EnableEditing property.

Example

Visual Basic for Applications
  Worksheets(1).QueryTables(1).EnableEditing = False

See Also