|
|
#1
05-22-2015, 03:57 AM
|
|||
|
|||
Paste over data validation
Hi,
I have data validation in a column in my excel sheet. But when ever i copy data from another cell to any cell having data validation it allows to overwrite that data. I dont want to use any VBA macro to disallow this paste over validation. Kindly suggest any other option for the same. So that only option in drop down can be selected and no any other copied data. Please remeber i dont want to use any macro. Thnaks 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 data validation from another sheet
|
paulys | Excel | 1 | 06-30-2014 01:40 AM |
|
Data Validation drop down
|
rkalapura | Excel | 1 | 05-27-2012 02:23 AM |
| If/then formulas with data validation | shira47 | Excel | 1 | 04-09-2012 05:14 AM |
|
Data validation using indirect function
|
BullMouse | Excel | 2 | 11-30-2011 05:25 PM |
| Data validation with IF | Klyxrastafari | Excel | 1 | 10-03-2011 04:41 PM |
Windows XP 
Office 2010 32bit
Threaded Mode