Unlocked cells still locked?

M

mauddib

Description of sheet:

Cells user uses are in columns A-F

Queries are also on the sheet but they are over in columns AA to AG

What I did:

Select all cells in the workbook, formated them to unlocked.
Selected 5 cells in column A, formatted them to locked.
Protected the sheet for CONTENT ONLY.

Problem:

The queries refresh each time the workbook opens. But im getting
messages saying "the cell you are trying to edit is locked" then im
asked if i want to continue refreshing queries.

But these cells arent locked!! Whats going wrong?
 
D

Debra Dalgleish

You can't refresh a query on a protected worksheet. You could use a
macro to unprotect, refresh, then reprotect.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top