VBA Row Lock

Pinaceous

Well-known Member
Joined
Jun 11, 2014
Messages
589
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...

Code:
    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.
 

Forum statistics

Threads
1,085,201
Messages
5,382,308
Members
401,781
Latest member
lozzeroooni

Some videos you may like

This Week's Hot Topics

Top