• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Stop Data Validation Override

Hi,

I have an issue with a workbook that I am creating. I need entries to be whole numbers and I set the data validation for that. The issue (seems to be a famous one actually) is that values can be pasted in that do not follow the rule. Is there code that can says if there is data validation in any cell, it must be honored. Hoping this runs regularly and does not have be be ran manually. I have tried a couple codes that I have found and have not been able to get it to work.

Attached is my workbook. The ones that have validation are a little random on my "Template" sheet. Thanks!
 

Attachments

  • New MYP Template (1st Interim).xlsm
    58.2 KB · Views: 1
Back
Top