I don't say no to the PC- I say it to the player. ;)
It depends on the situation, but I try not to say no.
If the player is excited about something, then I would rather take advantage of that excitement and compromise in a way to work it into my campeign.
That is preferable to them feeling...