Billy Connolly has said "men will have to get a grip on themselves" in the wake of the sexual harassment scandal gripping the entertainment industry.