Forum Discussion

CSMDKU's avatar
CSMDKU
Copper Contributor
May 14, 2020
Solved

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 s...
excel
Formulas and Functions
Macros and VBA
office 365
  • peteryac60's avatar
    peteryac60
    May 25, 2020

    CSMDKU 

     

    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

     

     

     

CSMDKU's avatar
CSMDKU
Copper Contributor
May 25, 2020

peteryac60 

 

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. 

Resources