Sheet protection problem

C

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/
 
G

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
 

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