Disable one Macro with another Macro

[Guest]

Is it possible to disable a macro and prevent it from running with a command
from another macro?

 

[Jim Rech]

One way to do that is with a flag variable:

Dim DisableFlag As Boolean

Sub DisableTheMacro()
DisableFlag = True
End Sub

Sub EnableTheMacro()
DisableFlag = False
End Sub

Sub TheMacro()
If Not DisableFlag Then
MsgBox "The Macro has Run!"
End If
End Sub


--
Jim Rech
Excel MVP
| Is it possible to disable a macro and prevent it from running with a
command
| from another macro?
| --
| Andy T