
I wanted to lock some large lists to avoid accidental deletion of Hyperlinks and or other data so I highlighted the column headers and made sure that they were unlocked and un hidden but when I protect the sheet it disables the arrows.
I am guessing that you cannot lock it but hopefully, and as usual, you will prove me wrong