QueryTable.EnableEditing Property (Excel)
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
Worksheets(1).QueryTables(1).EnableEditing = False