| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
QueryTable.EnableEditing property (Excel) |
vbaxl10.chm518097 |
|
|
c8297f41-56fa-4d8c-6633-bbda0deb6257 |
05/03/2019 |
medium |
True if the user can edit the specified query table. False if the user can only refresh the query table. Read/write Boolean.
expression.EnableEditing
expression A variable that represents a QueryTable object.
If you import data by 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 by 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.
Use the QueryTable property of the ListObject to access the EnableEditing property.
This example sets query table one so that the user cannot edit it.
Worksheets(1).QueryTables(1).EnableEditing = False[!includeSupport and feedback]