Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
quick names removal before sheet move | Excel Discussion (Misc queries) | |||
Validation - removal of over an entire spreadsheet | Excel Discussion (Misc queries) | |||
Sheet removal...help please | Excel Discussion (Misc queries) | |||
Validation from another sheet | Excel Programming | |||
insert validation in sheet | Excel Programming |