May 14 2020 03:05 AM
Hi all,
I have a worksheet in which two columns are locked for editing with "protect worksheet". The problem is that I can't add any rows to the sheet now, even though the option to add rows is selected. When I select the option to select locked cells, then I can add rows again. But as you understand, this removes the purpose of the locked columns.
How can I resolve this problem?
Your help is much appreciated!
Kind regards
May 17 2020 04:38 AM
Can you share your workbook so I can look ?
As example the attached (blank) workbook has 2 columns protected (no PW) highlighted in yellow. You can not enter data into the columns (as expected) nor can you insert rows (also as expected).
If you attach your file we can look to see what is happening.
Peter
May 25 2020 12:37 AM
Attached is a empty copy of the workbook I want to use.
I have put comments in the columns/rows that must be locked for editing, these contain formulas.
May 25 2020 01:29 AM
May 25 2020 01:33 AM
May 25 2020 02:26 AM
May 25 2020 02:55 AM
Solution
Hi
when you protected the sheet you had not checked the very first option - Select Locked Cells.
That was all!
I would be grateful if you would mark this solution as complete!
many thanks,
Peter
May 25 2020 04:12 AM
Apr 19 2021 12:53 AM
Hi Peter
I tried replicating this but in my own sheet this doesn't work. I still can't add rows if the cells are locked. Does this have anything to do with the fact that it's my first columns that are locked or not?
PS I uploaded my file
May 25 2020 02:55 AM
Solution
Hi
when you protected the sheet you had not checked the very first option - Select Locked Cells.
That was all!
I would be grateful if you would mark this solution as complete!
many thanks,
Peter