“Menopause and work” is very sensitive subject, I went myself through it a year ago. I didn’t talk about menopause to my team, I know that even not every medical profession can understand how meno symptoms can be severe and effect your life, some GPs have very limited knowledge of it, so I didn’t expect my team would understand such things. I contacted HR and asked to put me in touch with someone who can help me, so they did. Of course because of foggy brain and low concentration ability I had to give up job, which I did before, I asked the company to move me to job which doesn’t require high concentration, I also had my hours cut and adjusted to my needs. Unfortunately when you feel too ill to work you need to lower your expectations and try to adjust everything in your life to your body needs. Nobody in my team knows my diagnosis, they only know I have disability, they don’t ask me about that and I never talk to them about that. I think it should be kept privately and I only talk to HR and a person who is responsible for disability matters at work.
This is just my experience, but I believe a lot of depends on company rules of course, how they can deal with it.