Protected sheet row is not deleted where data is delete

XLS Padlock
1

In my workbook one sheet is having Row deleting option enable.
After compilation if i want to delete row with selection, entire row data is delete instead of complete row.
As data is blank then its create problem to search data, search operation stop at blank row.

2

Can you try to activate the following option to see if it solves your problem?

image
image812×508 41.6 KB

3

The above portion is done even facing issues.
Below is a link to the file:
https://drive.google.com/file/d/1JHD3_H4rIdtkWBAQsVx5ndFOgqOyz2Vr/view?usp=sharing
Sheet entry is option to delete row, once i select row and delete content is deleted not row.

4

Thanks, During compilation Right click was disabled.
I enabled this option to delete the complete row.