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?

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?

Hi,

You CAN insert and delete rows when Excel is protected!

I can't duplicate your problem. If you choose Tools, Protection, Protect
Sheet and check Insert Rows and Delete Rows and click OK, you should be able
to insert and delete the rows from the worksheet.

It suggests that something else is going on. To get the insert row or
delete row command to work, you must either select the row number(s) or
choose the command Insert, Row. You can not right click a cell and choose
the Insert command because Excel thinks you are telling it you want to insert
a cell.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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?