Help with Case function on Macro - Beginner

I think you need to change to uCase:-

Select Case UCase(Target)
Case Is = "CLIENT"

Not sure why you need code to not do something , as in "Y"