Disable mouse clicks on a range of cells with validations

Asked By GarySD
26-Jan-10 09:48 PM
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 have never seen this.

Dave Peterson replied to GarySD
27-Jan-10 09:00 AM
I have never seen this.

Maybe you can share:
the version of excel that does this
the data|validation rule that you are using
the cell that is has that validation
and describe the data in that other range


--

Dave Peterson
Post Question To EggHeadCafe