Disable then reenable a macro
<p>I am using the following as a timestamp. I would like a button to disable it (so that I can edit without it recording times) and a button to enable it again. </p>

<pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.column = 12 And Target.Row = 9 Then
    If Target.Value = "" Then
        Target.Offset(0, 4).Value = ""
    Else
        Target.Offset(0, 4).Value = Format(Now, "mm/dd/yyyy HH:mm:ss")
    End If
ElseIf Target.column = 12 And (Target.Row &gt;= 10 And Target.Row &lt;= 600) Then
    If Target.Value = "" Then
        Target.Offset(-1, 5).Value = ""
    Else
        Target.Offset(-1, 5).Value = Format(Now, "mm/dd/yyyy HH:mm:ss")
    End If
End If
End Sub
</code></pre>