validation - removal from whloe sheet
 

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

validation - removal from whloe sheet
 

try
Cells.Validation.Delete

--
Don Guillett
SalesAid Software

"Todd F." wrote in message
...
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

validation - removal from whloe sheet
 

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

validation - removal from whloe sheet
 

thanks for the time

it works great

"JE McGimpsey" wrote:

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