Forum Discussion
Adding rows in worksheet with locked columns
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
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
8 Replies
- Hi,
This is exactly what I want, thanks!
Can you explain to me what you have done to accomplish this so I can do it myself?
Many thanks!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
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
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.
