Sort containing column labels in protected cells [closed]
Hello,
I have a sheet like this :
=============================== | LABEL 1 | LABEL 2 | LABEL 3 | <-- 3 protected cells =============================== | data 1 | data 2 | data 3 | |---------+---------+---------| | data 4 | data 5 | data 6 | |---------+---------+---------| | data 7 | data 8 | data 9 | |---------+---------+---------|
I need to protect first row containing column labels.
But when I try to sort data using a macro or using Sort menu, selecting LABEL 1 as Sort Key 1 and specifying in Options that range contains colum labels, operation fails due to cell protection even if protected cells (labels) do not have to be modified.
Is it a bug ?
Is there a workaround ?
Thanks in advance
Ed