Hi guys, I have a worksheet where the column is validated by a list.
As expected, when I type in an incorrect value I recieve an error message. But when I paste in an incorrect value it stays in the cell.
This should happen? Is there a way around this?
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.
yes this is a problem the only way around it that I know is to add a maros to disable paste
this macros will disable paste A1:A10
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks