If you want to hear yes, you have to hear no
It is often hard to hear no. It feels like a rejection. But in order to get the yeses, you need to take the risk. When you have a dream or a goal, hearing no is often part of it. It's not a comment on your value or the worth of your dream. It's part of the process.
So don't be dissuaded by a no. Just keep asking until you get your yes.