error comes in my code for hiding/unhiding

Spelling mistake. Missing the r in target. Also you need to use LCase as you're triggers (yes and no) are lower case

should be

LCase(Target.Value)

VBA Noob