ExcelBanter - Lists and Protection

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Lists and Protection (https://www.excelbanter.com/excel-programming/309400-lists-protection.html)

Floyd

Lists and Protection

There seems to be no programmatic control of inserts and deletes in list
objects when the worksheet is protected even when all protection options are
allowed.
Is there any way around this short of unprotecing/protecting the sheet.

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