Captions of CommandButtons disappear after buttons are clicked

Hello

I have a workbook with 5 sheets; on Sheet1, I have three CommandButtons, each directing to a unique Sub. Each Sub works by performing a semi-complex copy/paste from Sheet1 to one of the other Sheets (3, 4, and 5, respectively).

After clicking on one of the buttons, its Caption seemed to disappear. Because there was actually a very thin, broken, horizontal line of black left behind on the button, I suspected that the BackColor (which is opaque) was actually, somehow, being layered on top of the ForeColor in a glitchy way... but when I made the BackColor Transparent, the Caption did not reappear. I clicked on the other two buttons to see if this behavior would be repeated, and it was: their Captions also disappeared, but in those two cases there was no remaining line of black indicating that the Caption was still present but simply not displaying properly.

I then looked at the properties for each button, and the Caption was still present and unchanged for all three.

Then, for the first button, I was able to fix this by reopening the properties, deleting the last word of the Caption, and retyping it. Now when I click on that button, its caption remains visible. However, I tried this same fix with the other two buttons and it did not work.

Is this happening because excel is having a panic attack due to there being more than one CommandButton on a single sheet? Or are there too many sheets involved... or too many Subs pointing to all those different Sheets? Or is this a known issue with a known fix not related to excel's capacity limitations?

Thank you for any advice you can offer.

Hello elfsprin,

Welcome to the Forum!

My guess is the CommnadButtons are ActiveX controls and not Forms controls. Excel 2007 is quirky in many areas, especially where ActiveX controls are concerned. The easiest fix would be to replace the ActiveX controls with Forms controls, unless of course you need the event functionality of the ActiveX controls.