Franz from Italy suggested putting the following code into the View Code
"Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Not Intersect(Target, "A1") Is Nothing Then Call MyMacro
End Sub"

but now I am unable to record or view the code for any macros (and I'm not
still recording a previous one). I have deleted that code but still can't
record.