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

 

[rollis13]

Once you delete a macro it can no longer perform, so, the only thought I have is that you have the same code in the ThisWorkbook module with the name:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

 

[SewStage]

Once you delete a macro it can no longer perform, so, the only thought I have is that you have the same code in the ThisWorkbook module with the name:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

Hey thanks rollis. I have two other modules/macros in this workbook and neither of them have that code. Would it be hidden somewhere? Embedded outside a module? Would it work to save the workbook as a non-macro-enabled workbook (and then go back and recreate the macros I need and save it as a macro-enabled workbook again)?

 

[rollis13]

Maybe there is something hidden in the Excel's XLSTART folder.

 

[SewStage]

Maybe there is something hidden in the Excel's XLSTART folder.

Both the Users\... and Program Files...XLSTART folders are empty. This is driving me crazy.

 

[kevin9999]

Is there any chance of sharing your file? You can get rid of all the data first if you like - not needed to solve this problem.

 

[SewStage]

Maybe there is something hidden in the Excel's XLSTART folder.

I just changed my macro settings in the Trust Center Settings to Disable VBA macros except digitally signed macros...and that appears to have disabled that particular code. Ah crud - it disabled the other macros, too, and as soon as I re-enabled the one I don't want came back.

 

[SewStage]

Is there any chance of sharing your file? You can get rid of all the data first if you like - not needed to solve this problem.

Sure! Don't know how to do that here though other than XLBB and I had to get rid of it because it was crashing my system every time I tried to use it.

 

[kevin9999]

Share your file via Google Drive, Dropbox or similar file sharing platform & post the link here. Just remember to make the file available to anyone with the link.

 

[SewStage]

Is there any chance of sharing your file? You can get rid of all the data first if you like - not needed to solve this problem.

Would it help to see the other two modules/macros I'm running? I didn't write them - know very little about VBA - but maybe there's something in there that will stand out for you that I'm not seeing?