Posted to microsoft.public.excel.programming

external usenet poster

Posts: 109

Copy Paste overides data validation

Hello,

The data validation response i received on my intial posting worked when you
manually key in the same value preventing duplication but when i tried to
copy and paste the same value it ignored data validation and allowed a
duplicate entry. I need something that will worked weather manually keying or
copy and paste to prevent duplicates. Does this require VB or macro use?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data Validation - copy paste !	Christoffer Bloch Andersen	Excel Worksheet Functions	1	March 18th 09 01:22 PM
Data Validation (copy paste error)	Christoffer Bloch Andersen	Excel Worksheet Functions	0	February 3rd 09 01:45 PM
Data Validation (copy paste error)	Christoffer Bloch Andersen	Excel Worksheet Functions	0	January 26th 09 11:53 AM
problem data validation and copy/paste	Theo	Excel Worksheet Functions	2	January 13th 08 08:30 PM
Copy/Paste over rides data validation	jk	Setting up and Configuration of Excel	1	July 23rd 06 03:39 AM

All times are GMT +1. The time now is 05:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us