Hide Column Based on Value in Cells

[DSS_DSS]

Dear All,

I am attempting to program a macro that will automatically hide column "G" when cell F9 is "FALSE." I wrote the code below, but it does not work. Do you have any suggestions?

Private Sub Worksheet_Change(ByVal Target As Range)​

If Target.Address = "$F$9" Then​

Columns("G").EntireColumn.Hidden = (Target.Value = "FALSE")​

End If​

End Sub​

 

[sweeneytime]

I tested the below and it works for me, make sure it is saved in the correct sheet in the vba editor. Let me know how it goes.

Private Sub Worksheet_Change(ByVal Target As Range)
    
    
    If Range("F9") = "False" Then
        Columns("G:G").EntireColumn.Hidden = True
    End If

End Sub