No shouldn’t stop you from anything in life. A yes will always come and sometimes no teaches you a lot about yourself. It’s necessary in life and can make you a stronger person and mature you.
Hearing no doesn’t mean you aren’t talented, it just means there is something else out there for you. Keep going and don’t be intimidated. Go after what you want in life and never give up even if you hear no.