Hello excelites!!!

I would like to ask if there is a macro code for locking a certain column, example, column D wherein all the formula entries for that column would not be clicked... I tried to lock using the properties but it distorts also the vba code I used.. So I would like to ask if there's a macro for locking columns...

Im trying to lock columns B,C,D,E and H so that my colleagues will not be changing the formula I used on these cells on the said columns.