Excel - 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?
Dave Peterson replied to GarySD
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
VBA Validation between two Times Excel Good Afternoon. I have some code (below) that adds validation to a certain cell The test code gives some messages to show how it is working. Cells with invalid times are blanked. You can enter a single time manually or paste a range into column As Range Dim sCell As Range Dim endCell As Range Dim cellRow As Long Dim Times(24, 2) As Date Times(1, 1) = #12:00:00 AM# Times(1, 2) = #12:59:00 AM# Times(2, 1) = #1:00:00 AM# Times(2, 2) = #1:59:00 AM Times(3, 1) = #2:00:00 AM# Times(3, 2) = #2:59:00 AM# Times(4
average of times Excel i have times listed as "h:mm" and i would like to show the average. note that the times are calculated, not entered manually. formula in time row: = TEXT(C2-B2, "h:mm") what formula would i put in the cell where i want the average of all times? thanks for your help. Excel Miscellaneous Discussions AVERAGE (1) TIMEVALUE (1) TEXT (1) M, If with Ctrl-Shift-Enter, not just Enter. It might be simpler to just keep your times in true date-time format rather than converting to text. In your original formula, use yes, i meant the second solution ( = C2-B2). Thanks, you are awesome. keywords: average, of, times description: i have times listed as h:mm and i would like to show the average. note that the times are calculated, not entered manually. formula in time row: = TEXT(C
summing times Excel I'm tring to create a daily log / time sheet which will have start and stop times in adjecent columns. My problem is there may, or may not, be mutiple shift seprations with randomly located blank colmns seperating the end times and begin times. A B 6:00 am 07:00am 7:05 am 12:30pm 12:35 pm B), "h:mm")-text(min(A:A), "h:mm") This works fine without mutiple shift times but in my line of work that is very rare. Like in his case the A10) Or, with regular entry = SUMPRODUCT(B1:B10-A1:A10) Where B1:B10 are ending times, and A1:A10 are starting times. You may have problems when times are wrapping aroung midnight - unless you also enter the date with the time. HTH, Bernie
please help w / a time formula Excel I have 5 times fields the start times are in columns A & B and the end times are in Columns C, D & E. They are not in order, but cols A or I get the #of minutes between the earliest start time and latest of the end times. thank you zb Excel Worksheet Discussions MAX (1) MIN (1) = MAX(C10:E10)-MIN(A10 Hope this helps. Pete keywords: please, help, w / , a, time, formula description: I have 5 times fields the start times are in columns A & B and the end times are in Columns C, D & E. They are not in order, but cols A or
Manipulating imported times Excel Hi folks. I have copied some athletic times from a website into Excel 2007. These times look like 03:56.8 on the website and in the body of the worksheet. I want to convert these times into seconds, in this case 236.8 s. When I go to the formula bar the times are recorded in the form 12:03:57 a.m. I have tries various things post<g> Thanks for the feedback. Lots of good stuff for working with dates and times at Chip Pearson's site. Link to his Topic Index will get you started. http: / / www.cpearson.com / excel / topic.aspx Gord keywords: Manipulating, imported, times description: Hi folks. I have copied some athletic times from a website into Excel 2007. These times look like 03:56.8 on the