In my workbook I have a code on one worksheet that runs macros when the value of certain cells changes. I need to be able to clear the contents of those cells within a different code (in a module) without triggering the running of the other macros (but in any other instance they are run). Is there a way to 'disable' the in worksheet macro within my other macro to allow me to do this??
Bellow is a section of the code on my worksheet:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
Set rng = Target.Parent.Range("C7:H25")
If Target.Count > 1 Then Exit Sub
If Intersect(Target, rng) Is Nothing Then Exit Sub
Application.ScreenUpdating = False
Select Case Target.Address
Case "$E$19"
Generate_Parent_List
Bookmarks