Lock / Unlock Cell

[Terence]

Hi,

I would like to lock / unlock a whole column by using VBA
code. How to do it? Anyone knows?

Thanks.

Terence

 

[DomThePom]

(use the recorder!!)

Columns("H:H").Locked = False
Columns("H:H").Locked = true