EnableEditing Property Example
This example sets query table one so that the user cannot edit it.
Worksheets(1).QueryTables(1).EnableEditing = False