PDA

View Full Version : How to Protect a Sheet that has an Import from a QRY

yus786
08-07-2008, 12:29 PM
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

http://i10.photobucket.com/albums/a113/0000o0000/1.jpg

http://i10.photobucket.com/albums/a113/0000o0000/2.jpg

Any idea's anyone?
scott-atkinson
08-20-2008, 01:22 AM
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

http://i10.photobucket.com/albums/a113/0000o0000/1.jpg

http://i10.photobucket.com/albums/a113/0000o0000/2.jpg

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