Excel 2007 : Can't insert row in a table on protected worksheet

Do you have any ideas on where to look for those problems? I've googled my problem and have found nothing. I'll keep trying, thanks.

Although the right click won't let you insert Rows, you can select Insert / Rows from command menu and insert Rows.
Or try the attached sample with following macro. You can modify to suit your needs. Change the column and insert Password if desired. The Insert Button will insert Row below the selected Cell.

Sub Insert()

If Selection.Count = 1 Then
    If ActiveCell.Column = 3 Then
        ActiveSheet.Unprotect
        With ActiveSheet
        ActiveCell.Offset(1, 0).Select
        Selection.EntireRow.Insert
        End With
    End If
End If
ActiveSheet.Protect
End Sub

modytrane.

I do not have the ability to insert a new row into the table from the command menu.

I'm trying to avoid a macro if I have to, but thanks for the reply.

Make sure the cells are not locked.
I just tried it out. In my case, by default all cells are locked.
I had to unlock them, and then if I protect the worksheet [check appropriate boxes in Protect Sheet dialogue box], it allows me to insert Rows from the command menu. Right click still doesn't work.
If it still doesn't work attach your file here to see if it works for others, then you'll know if it's the Excel setup in your computer.
modytrane

I just unlocked all cells and it still wouldn't let me insert a new row... I wish I could post the file, but it's for my company so I can't. A co-worker has the same problem with the file, so I'm guessing it's the file. I'll do more searching for a solution, thanks for the help.