Allowing separate Macro onto same worksheet per cell values?

[LeviA]

I am very green with Macros. I have a worksheet where a Macro is being used to hide or unhide a separate worksheet based on a dropdown value in a particular cell. My issue is, I need to do this to a 2nd drop down that will hide or unhide a separate worksheet from the previous as well. I am not sure how this should be handled. Below is what I have currently for the first drop down.

Private Sub Worksheet_Change(ByVal Target As Range)If [M19] = "Yes" Then
Sheets("1").Visible = True
Else
Sheets("1").Visible = False
End If
End Sub


This is what I need additionally

Private Sub Worksheet_Change(ByVal Target As Range)If [M20] = "Yes" Then
Sheets("2").Visible = True
Else
Sheets("2").Visible = False
End If
End Sub

 

[Kamolga]

[COLOR=#333333]Private Sub Worksheet_Change(ByVal Target As Range)
On error resume next
If [M19] = "Yes" Then[/COLOR]
[COLOR=#333333]Sheets("1").Visible = True[/COLOR]
[COLOR=#333333]Else[/COLOR]
[COLOR=#333333]Sheets("1").Visible = False[/COLOR]
[COLOR=#333333]End If[/COLOR]
[COLOR=#333333]If [M20] = "Yes" Then[/COLOR]
[COLOR=#333333]Sheets("2").Visible = True[/COLOR]
[COLOR=#333333]Else[/COLOR]
[COLOR=#333333]Sheets("2").Visible = False[/COLOR]
[COLOR=#333333]End If[/COLOR]
[COLOR=#333333]End Sub[/COLOR]

 

[LeviA]

Thank you for the help, I appreciate it. Hopefully I can learn the basics before too long and get some of this down.