VBA code to read the value of a RANGE NAME and use it as Validation

Check it

Sub Button2_Click()
    Dim r As Range
    Set r = Range("A1")

    If r.Value = "No Revision" Then
        MsgBox r.Value
    Else
        MsgBox r.Value & " Selected"
        MsgBox "this is where you run the SaveMAcro "
    End If
End Sub