need to disallow pasting into cells directly
 

Need to disallow pasting into cells directly without selecting
I have some validations in the cell, for maxlengths etc. But, when I
paste the text directly into the cell (without going into the cell
first), the validation is removed. Even when I do paste special as
text, then the validation is not removed, but doesnt work. So, I need
to disallow pasting into cells directly without going into the cell
first, so that validation remains.


---
Message posted from http://www.ExcelForum.com/