How do I auto refresh my macro?

[jjt1973]

I have created a template that will be used by our national sales team. I have written a macro and will be adding more. This template will need to be able to refresh everytime it is opened so that the macros automatically turn on and refresh with each scenario. Here is the current macro running:

Sub channel()
'This macro will be used to hide row 3 if not active row.

If [E2].Value = "" Then
Range("A3:I3").EntireRow.Hidden = True
End If

If [E2].Value = MN Then
Range("A3:I3").EntireRow.Hidden = True
End If

If [E2].Value = NY Then
Range("A3:I3").EntireRow.Hidden = False
End If

If [E2].Value = WI Then
Range("A3:I3").EntireRow.Hidden = False
End If

End Sub

Thanks.

JJT

 

[jjt1973]

No change. Rows still don't unhide. Am I doing something wrong? I took out all of the IF statements in favor of the code you gave.

 

[jjt1973]

No change. The rows still won't unhide. Am I doing something wrong?

 

[VoG]

I ran this and it hid row 3

Sub test()
Range("A3:K3").EntireRow.Hidden = [E2].Value = ""
End Sub

I then entered a value in E2 and ran it again and it unhid row 3.

 

[jjt1973]

It did not unhide the other rows. Also, I need them to unhide if certain criteria is met. Can I attach the workbook for you to see?