#here will learn how to protect cells, range and column in Excel #Please do this
Set sht= thisworkbook.sheets(1)
sht.cells.select
Selection.locked= false
Sht.range("A:A").select
Selection.locked = true
Sht.protect password:="your password"
If this helps you please like share and subscribe#