if the person is famous and you have worked closely with that person, then i think it's great. if you worked as Bill Gates' assistant for 2 years, it would be great to get a recommendation from him.
i have met some high profile CEOs and have been working pretty closely with one for the past 5 years. I meet him 2-3 times per year (which is a lot for a guy like him). He would have written a pretty nice recommendation for me but since we don't work together on an almost daily basis, i opted against it.
and if you work at microsoft and you've seen bill gates at some company functions and that's the extent of how you know him...uh, no.
or if you're getting a recommendation from pamela anderson because she's hot and you met her at a party....uh, no.
My Wharton Blog - http://www.whartonblog.com
Wharton MBA for Executives Ambassador - http://gmatclub.com/forum/128-t66295
My Story - http://gmatclub.com/forum/102-t49770