Hi,
The problem I'm facing is: If I protect a worksheet, then I'm unable to insert/delete rows in a List (Excel 2003) or Table (Excel 2007).

I've created an excel workbook that uses XML Maps which are mapped to Excel Lists. The list data is populated based on XML, and the user can also insert/delete rows in the list. All of this works fine before I protect the worksheet.
Now I would like to protect some ranges on the worksheet from user updates. So, using Tools->Protection->Allow Users to Edit Ranges, I specified the entire list range as a range that the user can edit. Then I did Tools->Protection->Protect Sheet (with all the checkboxes selected on the various options).

But once I protect the worksheet, the Insert Row option on the list is no longer enabled. Even inserting a row through VBA gives an error saying the action is not supported.

Is there any way to support inserting rows in a list on a worksheet that is protected?

Thanks,
Sam