ExcelBanter - Excel List on Protected Sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel List on Protected Sheet (https://www.excelbanter.com/excel-discussion-misc-queries/226155-excel-list-protected-sheet.html)

Lori H.[_2_]

Excel List on Protected Sheet

I have a range that is an Excel List.
Regardless of whether all cells in the list are unlocked (or if some columns
are locked), if the sheet is protected, the list doesn't activate (so the
list doesn't extend to include the new row).

Is there a way around that?

All times are GMT +1. The time now is 02:30 AM.