I was working on a new version of my pricing form.
Yesterday everything was fine, macros were doing what they were supposed to.
I know I deleted some that were no longer required, perhaps that messed something up.
I can't find anything wrong though, I am not well experienced in code.
Can someone proof this and see if it's good.
thanks
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Application.EnableEvents = False
On Error Resume Next
Select Case LCase(Target.Worksheet.Name)
Case "order", "order (2)", "order (3)", "order (4)"
If Not Intersect(Target, Target.Worksheet.Range("J6")) Is Nothing Then
Target.Worksheet.Range("H3:J3,L3:N3,M6:Q6").ClearContents
End If
If Not Intersect(Target, Target.Worksheet.Range("M6")) Is Nothing Then
Target.Worksheet.Range("H3:J3,L3:N3").ClearContents
End If
If Not Intersect(Target, Target.Worksheet.Range("B14:B50")) Is Nothing Then
Target.Worksheet.Range("C" & Target.Row & ":E" & Target.Row).ClearContents
End If
Case "order (5)"
If Not Intersect(Target, Target.Worksheet.Range("J6")) Is Nothing Then
Target.Worksheet.Range("H3:J3,L3:N3,M6:Q6").ClearContents
End If
If Not Intersect(Target, Target.Worksheet.Range("M6")) Is Nothing Then
Target.Worksheet.Range("H3:J3,L3:N3").ClearContents
End If
If Not Intersect(Target, Target.Worksheet.Range("B14:B23")) Is Nothing Then
Target.Worksheet.Range("C" & Target.Row & ":E" & Target.Row).ClearContents
End If
On Error GoTo 0
Case Else
End Select
Application.EnableEvents = True
End Sub
Bookmarks