Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,616
- Office Version
- 365
- 2016
- Platform
- Windows
I am looking for the correct VBA syntax to lock the cells of row and two.
My attempt below produces an error.
I'm certain I will kick myself for the simplicity of the solution. I'm just having a moment of old age.
My attempt below produces an error.
Rich (BB code):
With ws_data
.Unprotect
.Cells.Locked = False
.Rows(1, 2).cells.Locked = True
End With
I'm certain I will kick myself for the simplicity of the solution. I'm just having a moment of old age.