Hi Rocky,
I like to use the double click event better for this type of X or not X. My normal is to double click in Column A with this code:
![]()
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Column <> 1 Then GoTo Ender If Target.Row = 1 Then GoTo Ender If Target = "x" Then Target = "" GoTo Ender End If If Target = "" Then Target = "x" End If Ender: Cancel = True End Sub
Bookmarks