Maybe he's inadvertently trying to motivate you... personally, the more i hear the word "no", the more I'm inclined to go after something. Use it as motivation.

I can't tell you how many times I've heard this too. Just realize it only takes one "yes"... or whatever you're looking for to make it happen.