Casino Royale director Martin Campbell says Ewan McGregor was approached to play to play James Bond, but turned the part down.