VBA Row Lock

[Pinaceous]

Hi All,

I've come to the conclusion that I don't know how to do this.

I've tried to lock a row with a code but it appears to lock every row.

For example; If I'm trying to lock Range ("B10:M10") but after I run my code it locks every row that has an entry.

Very strange to me...

    Range("B10:M10").Select
    Selection.Locked = True
    
    ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

Does anyone have any suggestions or ideas, because I'm fresh out of ideas.

Thank you,
pinaceous

PS. This might help, its part of a table.

 

[alansidman]

https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/146584-locking-rows-from-editing