I have a table that I want my users to be able to expand to the right with new data, if needed. This table is on a sheet that I need to protect. When the sheet is unprotected and I enter data to the right of the table, the table properly expands to encompass the newly entered data. If I unlock the cells to the right of the table then protect the sheet, I can enter the new data to the right of the table, but the table doesn't expand to right. How do I fix this problem?
Thanks
RR
Bookmarks