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