Is there a way to disable a macro based on the value of a cell?
Probably not. But you could put a check in the macro to see if it should
continue:
Option Explicit
Sub testme()
dim myValToCheck as variant
myvaltocheck = activesheet.range("a1").value
if ucase(myvaltocheck) = ucase("Stop") then
exit sub
end if
'real code here
End Sub
Jeff wrote:
Is there a way to disable (or turn off) a particular macro based on the value
of a cell?
--
Dave Peterson
|