protect from deleting rows

[ckane]

Is there a way to protect a sheet from someone deleting a row and then still
be able to sort data? Column A and rows 1-6 are not part of the sort. The
rest of the rows (up to #345) and columns B-P do need to be sorted. Thanks
for your help.

 

[Ken]

ckane ...

Select ... Tools ... Protection ... Unprotect

Select Range of Cells you wish to Sort
Select Format Cells
Select Protection
Uncheck "Locked"

Now select ... Tools ... Protection ... Protect
In the pop-up Menu ... check ... Allow Sort
Click OK

I think this will do what you want ... Kha

 

[ckane]

Thank you Ken

ckane ...

Select ... Tools ... Protection ... Unprotect

Select Range of Cells you wish to Sort
Select Format Cells
Select Protection
Uncheck "Locked"

Now select ... Tools ... Protection ... Protect
In the pop-up Menu ... check ... Allow Sort
Click OK

I think this will do what you want ... Kha