Control Button disappear when criteria met

I have a sheet with names, months and if "Met?" (criteria). Next to each entry row, active control buttons are available for user to click to erase Name and Month if met. (The "Met" column has formulas build in but is not relevant to this inquiry).

I am looking for a code to make the Control button only visible if criteria met (If "Yes" indicated) and disappear if criteria not met. Also if made visible, button on each row should erase data in columns A & B of subsequent row. I began below code but it only addresses first part of my request and also does not work !!

Private Sub Worksheet_Change(ByVal Target As Range)

'HiddenButton
    Sheet6.Select
    If Range("C2") = "Yes" Then
    Sheet6.Shapes.Range(Array("CommandButton1")).Visible = True
    Else
    Sheet6.Shapes.Range(Array("CommandButton1")).Visible = False
    End If

End Sub

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer


Thanks kindly to anyone offering solution: