One way:

ActiveSheet.Cells.Validation.Delete


In article ,
"Todd F." wrote:

Is there a way to remove data valaidation from the active sheet by
programming.

I wan tot give some non computer types and myself the ability to open a
sheet (unprotected) and just do a one button removal on all data validation.



Hey thanks