View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default 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