Good idea. Then i prefer this;

Choose a cell which has not important data. I assume "A1" is this one.

Then put this in the program:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.Range("A1").Select
End Sub

That means when the user choose a Range or Ranges it will be forced to choose
onle the Cell "A1". He can just change the data  in "A1" .

Is it close to what you're looking for?