macro to run IF condition met
if range("A1").value = 0 then
Range("B9:I16").Select
ActiveSheet.Unprotect
else
msgbox "delete list"
end if
--
HTH...
Jim Thomlinson
"Savuti" wrote:
please help.... I need to have a macro run under the following criteria:
if cell A1 = 0 then run macro
if cell A1 0 then don't run macro and show message box to say "delete list"
below is the begining of the existing code ...... thanks
Range("B9:I16").Select
ActiveSheet.Unprotect
|