I have a situation where i have unlocked all the cells in my
spreadsheet and i am protecting the sheet, but allowing users to edit
the unlocked cells. The problem i am having is that my row 1 and row 2
(even though they are unlocked) get the 'this cell is protected' messge
when the use trys to edit it.

Any suggestions?

Are you sure you unlocked all the cells in rows 1 and 2?



wrote:

I have a situation where i have unlocked all the cells in my
spreadsheet and i am protecting the sheet, but allowing users to edit
the unlocked cells. The problem i am having is that my row 1 and row 2
(even though they are unlocked) get the 'this cell is protected' messge
when the use trys to edit it.

Any suggestions?

--

Dave Peterson

all the cells are unlocked in the spreadsheet. Does it have to do with
Excel thinking those are header rows, so they can't be edited? If that
is the case, why does excel do this?