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

I have a table that is in a protected worksheet. When the worksheet is not protected I can right-click in any of the cells and insert a new row. When I protect the worksheet, even with all allowable options checked, I cannot insert a new row in the table.

The only way I know to get a new row is to go to the last cell in the table where there is data and push the "tab" button, which will add a new row.

Is there a fix to my problem? Thank you.

Well that's the obvious answer, but the sheet has to be protected since it is a company wide Excel file.

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.

Please Login or Register  to view this content.

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.