ExcelBanter - Keep asterisk feature in a List while protecting sheet

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

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

- - Keep asterisk feature in a List while protecting sheet (https://www.excelbanter.com/excel-discussion-misc-queries/102469-keep-asterisk-feature-list-while-protecting-sheet.html)

NSAA

Keep asterisk feature in a List while protecting sheet

I have created a List but when I protect the sheet, the row with the asterisk
disappears and I lose the function to automatically add a row. How can I
protect the worksheet with the List and retain this feature?

exceluserforeman

Keep asterisk feature in a List while protecting sheet

Use '*

"NSAA" wrote:

I have created a List but when I protect the sheet, the row with the asterisk
disappears and I lose the function to automatically add a row. How can I
protect the worksheet with the List and retain this feature?

All times are GMT +1. The time now is 02:22 PM.