Hi to all,
I have a excel sheet that contain data validation for checking character lenth. If i copy / paste a value in that cell the validation doesn't check, until i press f2 for rechecking. The file contain around 1000 cell in each colomn with several rows with different validation viz date check, number check, and every time i have to press f2 in each cell. Any other option, plz help
Copy paste will override the data validation. Data Validation will work when manual input occurs. So just add a piece of code to disable copy paste In The Validation Range.
Try some thing like this to restrict copy/paste.
Do right click on sheet tab and paste the below code. Return to excel and check.
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks