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

 

[kevin9999]

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?

No. Need to see the entire file.

 

[PeteWright]

Maybe you got a macro in a hidden Workbook.
To check this, just go to any open Workbook, then in the View Ribbon klick "unhide".

 

[SewStage]

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.

PLAYGROUND.xlsm

Microsoft Excel Workbook

1drv.ms

 

[SewStage]

Maybe you got a macro in a hidden Workbook.
To check this, just go to any open Workbook, then in the View Ribbon klick "unhide".

View attachment 100373

Thanks Pete - Unhide is grayed out.

 

[kevin9999]

Thanks for that Are you aware that you still have worksheet change event code in Sheet2 (Material purchases) and Sheet3 (Material usage)? If you no longer want that code, go to those sheets and right-click on the tab name/select View code/ delete the code that appears on the right of screen/ repeat for the other sheet/ save the file.

 

[SewStage]

Thanks for that Are you aware that you still have worksheet change event code in Sheet2 (Material purchases) and Sheet3 (Material usage)? If you no longer want that code, go to those sheets and right-click on the tab name/select View code/ delete the code that appears on the right of screen/ repeat for the other sheet/ save the file.

Those are the two that I *do* need to keep.

 

[SewStage]

Thanks for that Are you aware that you still have worksheet change event code in Sheet2 (Material purchases) and Sheet3 (Material usage)? If you no longer want that code, go to those sheets and right-click on the tab name/select View code/ delete the code that appears on the right of screen/ repeat for the other sheet/ save the file.

OMG that's it - I just realized that Sheet 2 is Material purchases and not Material usage; that is the code I need to remove! I don't see how to do that...? When I double click Sheet 2, the worksheet change even code displays but it's not listed under Modules.

 

[kevin9999]

OMG that's it - I just realized that Sheet 2 is Material purchases and not Material usage; that is the code I need to remove! I don't see how to do that...? When I double click Sheet 2, the worksheet change even code displays but it's not listed under Modules.
View attachment 100374

That's because sheet code isn't in a standard module, it 'resides' in the sheet code area.

 

[SewStage]

That's because sheet code isn't in a standard module, it 'resides' in the sheet code area.

I see another version of that same code in Material Usage. Okay...is it possible to remove these?

 

[kevin9999]

I see another version of that same code in Material Usage. Okay...is it possible to remove these?

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