| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Paste" overwrites Verification Controls
I have a spreadsheet with many cells set to Validate - List. The drop down
lists work fine... UNLESS someone comes along and "Pastes" something into the cell at which time, the pasted data is there, the Validate does not prevent it and the drop-down list is no longer available for that cell. What can I do to make "Validation" stronger so no one can enter anything but what is in the list? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
| Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| activex controls, no "Control tab" | Excel Discussion (Misc queries) | |||
![Mack Neff[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
