Disable mouse clicks on a range of cells with validations
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? |
Disable mouse clicks on a range of cells with validations
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 |
All times are GMT +1. The time now is 09:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com