Setting data validation alerts to off to selected range in code

How can I change the the data validation on the newly selected range in this code without resetting the other information in the data validation. I want when you select your range to change the format in the macro for it to also set the validation error alerts off .

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim myFrmt As String, rng As Range
    If Target.Row <> 11 Then Exit Sub
    If Intersect(Target, Range("b11,d11,f11,h11")) Is Nothing Then Exit Sub
    If Target.Value = "" Then Exit Sub
    On Error Resume Next
    Set rng = Application.InputBox("Select range to change the format", Type:=8)
    On Error GoTo 0
    If rng Is Nothing Then Exit Sub
    rng.NumberFormat = "@"
    Select Case Target.Column
        Case 2
            myFrmt = IIf(Target.Value = "XXT", "\NV-0000", "\NV-0000")
        Case 4
            myFrmt = IIf(Target.Value = "XXT", "\EX-0000", "\NV-0000")
        Case 6
            myFrmt = IIf(Target.Value = "XXT", "\DX-0000", "\NV-0000")
        Case 8
            myFrmt = IIf(Target.Value = "XXT", "\GX-0000", "\NV-0000")
    End Select
    rng.NumberFormat = myFrmt & ";;" & myFrmt & ";" & Replace(myFrmt, "0000", "@")
End Sub