Disable mouse clicks on a range of cells with validations

  • Thread starter Thread starter GarySD
  • Start date Start date
G

GarySD

I have ranges of cells that have a validation based on the results of a
formula in another portion of the sheet. The idea is prevent the end user
from entering a value that has already been entered xxx times within given
column. Everything works fine. The problem is that the end user can bypass
the validation by entering the value they want and simply "clicking" over to
another cell. Is there a script that I can insert into the spreadsheet that
will either disable mouse clicks within a given range(s) or force the end
user to either use the "enter" key or the "arrow" key?
 
I've never seen this.

Maybe you can share:
the version of excel that does this
the data|validation rule that you're using
the cell that's has that validation
and describe the data in that other range
 
Back
Top