Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range('k6:k13')) Is Nothing Then
If Target <> '' Then
ActiveSheet.Shapes('CommandButton' & Target.Row + 23).Visible = True
Else
ActiveSheet.Shapes('CommandButton' & Target.Row + 23).Visible = False
End If
End If
If Not Application.Intersect(Target, Range('k15:k17')) Is Nothing Then
If Target <> '' Then
ActiveSheet.Shapes('CommandButton' & Target.Row + 22).Visible = True
Else
ActiveSheet.Shapes('CommandButton' & Target.Row + 22).Visible = False
End If
End If
If Not Application.Intersect(Target, Range('k19:k20')) Is Nothing Then
If Target <> '' Then
ActiveSheet.Shapes('CommandButton' & Target.Row + 21).Visible = True
Else
ActiveSheet.Shapes('CommandButton' & Target.Row + 21).Visible = False
End If
End If
If Not Application.Intersect(Target, Range('k20')) Is Nothing Then
If Target <> '' Then
ActiveSheet.Shapes('CommandButton' & Target.Row + 21).Visible = True
Else
ActiveSheet.Shapes('CommandButton' & Target.Row + 21).Visible = False
End If
End If
End Sub