VBA Data Validation Question

I actually got that far. The issue is that the cells without the corresponding asterisk still have the drop down menu, even though it's "deactivated". I was hoping there would be a way that for those cells there would be no validation at all, meaning no drop down menu if you were to click on the cell....That's why I was trying to steer away from conditional formatting, and stick with VBA, if it's even possible.....

Finally figured it out.

Sub ValidateStuff()
Dim rng2 As Range

    Set rng2 = Range("E17:E167")
    For Each cell In rng2
       
        If cell.Value <> "*" Then
            
            With cell.Offset(0, 12).Validation
                    .Delete
                    .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
                    Operator:=xlBetween, Formula1:="=MoreStuff"
                End With
        End If
    Next

End Sub