Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Range with 2 validations | Excel Worksheet Functions | |||
Not able to select range of cells with mouse. | New Users to Excel | |||
Repetitive keystrokes and/or mouse clicks | Excel Discussion (Misc queries) | |||
disable right click on mouse | Excel Discussion (Misc queries) | |||
Disable a range of Cells | Excel Worksheet Functions |