Create Multiple Worksheet_Change

[Sundae]

Hi, I have the following code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("a15").Value = "Exempt" And Range("F6").Value = "Exempt" Then
Rows("19").EntireRow.Hidden = True
Rows("21").EntireRow.Hidden = True
ElseIf Range("a15").Value = "Exempt" And Range("F6").Value = "Non-exempt" Then
Rows("19").EntireRow.Hidden = False
Rows("21").EntireRow.Hidden = False
ElseIf Range("a15").Value = "Non-exempt" And Range("F6").Value = "Exempt" Then
Rows("19").EntireRow.Hidden = False
Rows("21").EntireRow.Hidden = False
End If
End Sub

I need to add a second Worksheet_change but I get the error ambiguous name detected vba - where do I change my code name? Thank you!!!

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel...tliple-worksheet_change-event-procedures.html

Glad to see that you figured out how to post your own thread, but I had already moved your original question to its own thread and it already has replies.
So we are locking this thread (per forum rules on duplicate posts) and leaving the other one open.