You know the situation: You have carefully setup a workbook with intricate Validation schemes. But then along comes your user and he copies and pastes at will. Result: Validation zapped, workbook structure violated.
What to do? The only way I find to be reliable is to catch all possible paste operations. But this isn’t very easy, since there are a zilion ways to paste.
I have put together a sample workbook and an explanatory article on how one could go about protecting a workbook by intercepting paste operations.
Let me know what you think!!
Jan Karel Pieterse