Hello,
I have created a userform that pops up when the user double clik on a cell of a sheet.
It works but at the end of the macro, the cursor edits the cell where I doubleclicked and I have to type Esc no to change what it is written on it. As there will be other users using this workbook I would like to avoid the risk of changing what it is written on the cell.
What can I do in order no to select the cell once I exit the macro?

(Ideally I would also like to protect that cell where I doubleclick but if I do it the macro doesn't work.)

Here the code on the spreadsheet:
Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Intersect(Target, Range("e12")) Is Nothing Then
Else
CountrymoreLoc.Show
End If
End Sub
'double click on the spreadsheet allowances to run the macro
The code on the userform CountrymoreLoc:

Private Sub ChooseTwn_Click()
Sheets("Calculations").Range("b27") = ListOfTwn.Text
End Sub
Private Sub CmdClose_Click()
Unload Me
End Sub
Private Sub UserForm_Initialize()
Dim cLoc As Range
Dim ws As Worksheet
Set ws = Worksheets("Inflations")
For Each cLoc In ws.Range("CountryT")
With Me.ListOfTwn
.AddItem cLoc.Value
End With
Next cLoc
End Sub
Thank you very much for helping.