How to Protect a Sheet that has an Import from a QRY

[yus786]

I have a spreadsheet that has some queries imported from Access (Via DATA | Import External Data)

Anyways i would like to protect this spreadsheet but using the TOOLS | Protection method gets me the following message when i try to refresh my query

Any idea's anyone?

 

[scott-atkinson]

I have a spreadsheet that has some queries imported from Access (Via DATA | Import External Data)

Anyways i would like to protect this spreadsheet but using the TOOLS | Protection method gets me the following message when i try to refresh my query

Any idea's anyone?

Apoologies for stating the obvious, but it will not refresh beacuse the work book is protected.

Question: Why do you need to protect the sheet?
Question: How are your VBA skills?

Scotty