| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Data validation cells from copy paste
Hi,
I have unlocked some cells with data validation, now after protecting the work sheet, when the user types in data the validation is working fine. However it also allows user to copy - paste any value in these cells irrespective of the vaidaion conditions. Request you to please let me know how to correct this and make even copy - paste of data subject to data validation? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem data validation and copy/paste | Excel Worksheet Functions | |||
| Data Validation - Copypaste special problem | Excel Discussion (Misc queries) | |||
| Copy/Paste over rides data validation | Setting up and Configuration of Excel | |||
| Protect from copy/paste | Excel Discussion (Misc queries) | |||
| Data validation does not seem to work with copy/paste | Excel Discussion (Misc queries) | |||
Threaded Mode
