VBA for Locking Column

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.

I know how to lock cells without macro... But when I do that on my macro-enabled worksheets, it distorts the running vba codes... That's where I'm having problems...

This is why I was asking if it was possible to lock the whole columns using a VBA code.

Originally Posted by Andy Pope

Without details we have no idea what you mean by "distorts the running vba codes"

As I said if the sheet is protected you will need to unprotect it whilst the code in running and reapply it when finished.
The macro recorder will provide code need.

Hello Andy Pope!!!

Thanks for your response... Here is my worksheet which I'm working on... As you can see, the worksheet already has VBA codes which is working properly as I wanted it to be.. However, every time I lock the columns J, O, P and Q via putting on a "protected worksheet" status... and then I use the "Hide" and/or the "Reset" Button I made for the VBA Codes, Excel prompts me with "Error 400"...

Grading Sheet.xlsm

I wanted these columns J, O, P and Q to be locked so that my other colleagues won't be able to accidentally change the values inside it.

/The Macros have a password, it is "09193483966"/

Thank you very much!

Thank you very much!!!

It worked perfectly!