Disable Worksheet Change Event

[SewStage]

I no longer need this change event, but even though I've deleted the macro it's still performing copy/paste functionality that's starting to mess with my spreadsheet. How do I stop this, especially since I've deleted the macro? Is it as "simple" as creating it again with Application.EnableEvents = False?

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Not Intersect(Target, Sheets("Material Usage").Range("B5:B35")) Is Nothing Then
    Sheets("Material Usage").Select
    Range("B5:B35").Select
    Application.CutCopyMode = False
    Selection.Copy
  
    Sheets("Product Completion by Mo.").Select
    Range("B5").Select
    ActiveSheet.Paste
End If
Application.EnableEvents = True
End Sub

 

[SewStage]

To remove Sheet code, go to the sheet code, highlight it and hit delete

Sorry; long day. That worked - thank you so much!!!

 

[kevin9999]

Sorry; long day. That worked - thank you so much!!!
We all have days like that...