validation - removal from whloe sheet

[Guest]

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

 

[Don Guillett]

try
Cells.Validation.Delete

 

[JE McGimpsey]

One way:

ActiveSheet.Cells.Validation.Delete

 

[Guest]

thanks for the time

it works great

One way:

ActiveSheet.Cells.Validation.Delete