EnableEditing Property
True if the user can edit the specified query table. False if the user can only refresh the query table. Read/write Boolean.
Example
This example sets query table one so that the user cannot edit it.
Worksheets(1).QueryTables(1).EnableEditing = False