Because the purpose of Protecting a Worksheet is to prevent accidentally
deleting of rows/colums or cells, you have to unlock the rows or columns that
the user will be allowed to delete. To do this, Select the rows and or
columns that you will allow the users to delete at will, and from the Main
Menu Select:
Format-Cells
Click on the Protection Tab and remove the check mark from the "Locked" box

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"ttonkel" wrote:

I have a protected time sheet that I am revising for my job. I need to have
the worksheet protected but also need to be able to insert and delete rows.
When clicking on the protect worksheet button I check the boxes next to
insert rows and delete rows. Then I click protect.

After I protect it with or with out those options it won't let me add or
delete rows.

Why won't it let me do this? Does anyone have any ideas about how to fix it?