VBA - Hiding columns

[Anton1983]

Good afternoon.

I would like a macro whereby if D3 = "Exempt", column I disappears.

Thanks.

 

[Joe4]

Here is code that will run automatically upon cell D3 being updated.
Right-click on the sheet tab name at the bottom of the screen, select "View Code", and paste this code in the resulting VB Editor window:

Private Sub Worksheet_Change(ByVal Target As Range)

'   Run if value in D3 changes
    If Target.Address(0, 0) = "D3" Then
        Columns("I:I").EntireColumn.Hidden = (Target = "Exempt")
    End If

End Sub