Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Users overwriting cells with Validation set to "Lists"
I have a worksheet that I have produced for other people to use and so do
not maintain tight control over its application after it leaves me. I have a number of cells that have validation set to use only "Lists" and that works fine. The problem is that if someone "Copies" something into one of those cells, it overwrites the validation control and inserts whatever the rebellious user wants to insert and the List no longer functions for that cell. What can I do to make the limitation tighter so they can't enter anything - in any way - that is not on the list? Mack Neff |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Users overwriting cells with Validation set to "Lists"
In the Allow Box did you check list, if so only an entry from list should be
allowed -- William<"M" "Mack Neff" wrote: I have a worksheet that I have produced for other people to use and so do not maintain tight control over its application after it leaves me. I have a number of cells that have validation set to use only "Lists" and that works fine. The problem is that if someone "Copies" something into one of those cells, it overwrites the validation control and inserts whatever the rebellious user wants to insert and the List no longer functions for that cell. What can I do to make the limitation tighter so they can't enter anything - in any way - that is not on the list? Mack Neff |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Users overwriting cells with Validation set to "Lists"
This is the Error Check formula
=IF(ISBLANK(E3) , FALSE, IF (D3 = $A$3, ISERROR(MATCH(E3, $A$7: $A$10, 0)), The location of the list ISERROR(MATCH(E3,$A$13:$A$16,0)) The location of the list This is an error check formula should you need it? -- William<"M" "Sunday88310" wrote: In the Allow Box did you check list, if so only an entry from list should be allowed -- William<"M" "Mack Neff" wrote: I have a worksheet that I have produced for other people to use and so do not maintain tight control over its application after it leaves me. I have a number of cells that have validation set to use only "Lists" and that works fine. The problem is that if someone "Copies" something into one of those cells, it overwrites the validation control and inserts whatever the rebellious user wants to insert and the List no longer functions for that cell. What can I do to make the limitation tighter so they can't enter anything - in any way - that is not on the list? Mack Neff |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Users overwriting cells with Validation set to "Lists"
List is checked and a list name was provided.
One can not type anything into the cell that is not on the list, but "Paste" will overwrite the Validation Mack "Sunday88310" wrote in message ... In the Allow Box did you check list, if so only an entry from list should be allowed -- William<"M" "Mack Neff" wrote: I have a worksheet that I have produced for other people to use and so do not maintain tight control over its application after it leaves me. I have a number of cells that have validation set to use only "Lists" and that works fine. The problem is that if someone "Copies" something into one of those cells, it overwrites the validation control and inserts whatever the rebellious user wants to insert and the List no longer functions for that cell. What can I do to make the limitation tighter so they can't enter anything - in any way - that is not on the list? Mack Neff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
How can "data validation" be enforced in calculated cells | Excel Worksheet Functions | |||
cells formatted to tick when text value "Y" if or null if "N" | Excel Discussion (Misc queries) | |||
Protect shouldn't default to "allow users to select locked cells" | Setting up and Configuration of Excel |