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/

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 FormatCellsProtection.

Clear the "locked" option.

Now protect the sheet.


Gord Dibben MS Excel MVP

On Wed, 18 Mar 2009 14:21:02 -0700, carl
wrote:

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/