This part of the code will be executed whenever any cell on the sheet is double clicked.
    With Target
        If .Value = "£" Then
            .Value = "R"
        Else
            .Value = "£"
            Cancel = True
        End If
    End With
If you want to restrict the range it's executed on then use If statements similar to those in the preceding code.