ExcelBanter - Prevent users from deleting the first row of a list

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

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

- - Prevent users from deleting the first row of a list (https://www.excelbanter.com/excel-programming/344439-prevent-users-deleting-first-row-list.html)

nospammyplez

Prevent users from deleting the first row of a list

I have set up a worksheet with dynamic range names, such that deleting
the first row will break these names. Is there any way, other than
protecting sheets, to keep users from deleting the first row?

thanks

All times are GMT +1. The time now is 07:09 AM.