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, [...]
Read the complete post at http://www.dailydoseofexcel.com/archives/2007/12/17/catching-paste-operations/
Posted
Dec 17 2007, 02:27 PM
by
Daily Dose of Excel