[FONT="]I am trying to secure a worksheet using data validation. I want to prevent users from pasting over data validation fields, however I want to allow users to be able to still use the paste feature as long as the data is valid for the data validation. How can I do this VBA code?
I am using data validation for 6 columns (A, K, D, N, H, Y) and these columns are included different data validations. [/FONT]
I am using data validation for 6 columns (A, K, D, N, H, Y) and these columns are included different data validations. [/FONT]