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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've never seen this.
Maybe you can sha 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 GarySD wrote: 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? -- Dave Peterson |
Reply |
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 |