EnableEditing Property

Microsoft Excel Visual Basic

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