Have you had a hysterogram done

Tomorrow I go for a hysterogram, to see if I have a blockage in my Fallopian tubes or not. Has anyone on here had this before. Also my husband is suppose to have a spermanalysis done but is mortified. Also he said if there is something wrong he doesn't want to know.. What do I do?