Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Intersect(Target, Range("A6:A20")) Is Nothing = False Then If Target.Column <> 1 Then Exit Sub Cancel = True If Target.Value <> "●" Then Target.Value = "●" Else Target.Value = "" End If End If End Sub