Sheet protection problem

[carl]

I'm having problems with the protection function in excel 2003. I protect a
sheet but tick the boxes to allow row and column editing. But when I go back
in to the sheet it tells me that the sheet is protected and I am unable to
edit cells.

What is going on here? That doesn't make sense/

 

[Gord Dibben]

There are no tick boxes for row and column editing..........inserting,
yes.......editing, no.

In order to edit any cells on a protected sheet you must first unlock the
cells to edit then protect the sheet.

By default all cells on a protected sheet are locked.

Select the cells for editing and Format>Cells>Protection.

Clear the "locked" option.

Now protect the sheet.


Gord Dibben MS Excel MVP