Are data query and sheet protection impossible on the same sheet?

Hi,

Is there any VBA way to use Data Query and keep a column of cells and ActiveX controls protected?

I just need to keep the user from changing the formulas in columns A & B and a command button. Everything to the right and down from cell C17 is unprotected terrain where the imported data is to go.

Thanks,

Lawrence

Hi

Why don't you unprotect the sheet at the start of your sub and reprotect it when you've finished the data query?

Dion

Please Login or Register  to view this content.