Ask Your Question

Ed38's profile - activity

2019-10-20 16:03:35 +0100 received badge  Notable Question (source)
2019-10-20 16:03:35 +0100 received badge  Famous Question (source)
2018-09-11 18:34:36 +0100 received badge  Popular Question (source)
2018-09-11 12:55:47 +0100 marked best answer Sort containing column labels in protected cells

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

2018-09-11 12:55:47 +0100 received badge  Scholar (source)
2018-09-11 11:59:23 +0100 asked a question Sort containing column labels in protected cells

Sort containing column labels in protected cells Hello, I have a sheet like this : =============================== | L

2018-09-08 03:07:08 +0100 received badge  Famous Question (source)
2018-08-29 13:25:55 +0100 commented answer How to duplicate last row with formulas in a macro ?

Sorry, I have no enough points to mark my question as solved by my own answer.

2018-08-29 13:19:14 +0100 answered a question How to duplicate last row with formulas in a macro ?

I've finally found a solution inspired from an answer to an other question mixed with a recorded macro. Probably ugly f

2018-08-29 02:23:55 +0100 commented question How to duplicate last row with formulas in a macro ?

Sorry, my prior example only shows results after calculation. Second column "Sums" contains the sum of "Product1 + Prod

2018-08-27 19:57:07 +0100 received badge  Teacher (source)
2018-08-27 09:15:57 +0100 received badge  Notable Question (source)
2018-08-26 19:37:16 +0100 edited question How to duplicate last row with formulas in a macro ?

How to duplicate last row with formulas in a macro ? Hello, I'd like to create a button for adding rows at the bottom o

2018-08-26 19:34:54 +0100 received badge  Editor (source)
2018-08-26 19:34:54 +0100 edited question How to duplicate last row with formulas in a macro ?

How to duplicate last row with formulas in a macro ? Hello, I'd like to create a button for adding rows at the bottom o

2018-08-26 19:34:15 +0100 edited question How to duplicate last row with formulas in a macro ?

How to duplicate last row with formulas in a macro ? Hello, I'd like to create a button for adding rows at the bottom o

2018-08-26 18:55:28 +0100 answered a question What are the "autosave" options, and where is work saved?

Hello, Under "tools" there are no "options" "Options" is the last/lowest item in "Tools" menu, just after "Customi

2018-08-26 15:59:47 +0100 received badge  Popular Question (source)
2018-08-25 22:41:06 +0100 asked a question How to duplicate last row with formulas in a macro ?

How to duplicate last row with formulas in a macro ? Hello, I'd like to create a button for adding rows at the bottom o