How do I turn off data validation in Excel VBA?
How do I turn off data validation in Excel VBA? Follow these steps to delete a data validation drop down list in a Excel Worksheet.Select the cell that has drop down list.Choose Menu -> Data -> Data Validation.In Settings Tab, choose “Any Value” for Allow field.Click Ok. How do I turn off data validation in Excel? Select the cells with the drop-down list.Click Data >Data Validation.On the Settings tab, click Clear All.Click OK. How do I fix data validation list in Excel? Remove data validation - Select the cell or cells that contain the validation you want to delete, then...