Protect Sheet not allowing users to Insert/Delete rows

[pliant]

Hi,

I am using Excel 2003 and would like to Protect a sheet so that users can edit everything (eg. Insert/Delete rows/columns, Format rows/columns) except Locked Cells.

So I clicked on Tools > Protection > Protect Sheet > under Allow all users of this worksheet to: checked all boxes except "Select locked cells".

The locked cells are now protected however when I right click to add a row, the Insert and Delete items on the popup menu are greyed out.

I've found that I can insert a row by clicking the Insert > Rows in the top menu but can't find a way to delete it.

Does anyone know how to keep the items working in the right click popup?

Thanks!

 

[iggydarsa]

there is "insert rows" you should uncheck it

 

[pliant]

Don't you mean check it?

The header of the checkboxes reads -->

Allow all users of this worksheet to:
here i have checked Insert Rows (and all others except Select Locked Cells)

Unchecking it would disable Insert Rows...

 

[iggydarsa]

I thought you meant you wanted to disable insert action for the user

 

[pliant]

Nope, I want everything enabled except for "Select locked cells"

 

[iggydarsa]

I got your question now.. sorry for the delay... the problem is you are not allowinf the user select a cell naturally the right click is not allowing them to insert a row... let me think if there is a way to get around it

 

[iggydarsa]

IS the reason you dont want the user select a cell so that they dont change the value? I guess in order to fix the problem I gotta know what is the reason you are allowing everything but not "select cell"

 

[pliant]

Mainly so that users can't change fields headers and title and so they can easily tab between the fields they are supposed to fill in.

But they have to be able to insert/delete rows because there are a few sections that they may need to expand.