Turning a blind eye

I have just discovered my husband is having an affair. Since going through the menopause I have lost interest in sex and my husband has always had a high sex drive. I don't know whether I should just turn a blind eye to his affair as I don't want to break up our family and whether it is selfish to expect him to give up sex when in all other respects we have a happy and comfortable family life. Has anyone else had this problem and how did you deal with it?