How do I control the caption text on a disabled Excel 2007 Activex control using VBA?
Posted on 2014-12-03
I'm using Excel 2007 VBA to control the appearance of Activex controls (not Form controls - I know the difference). When I disable an Activex command button or Activex text box the caption text is displayed in a medium gray color with what appears to be a white drop shadow. I've spent hours Googling for a property that I can use to control this issue but to no avail. I've checked the list of properties for the respective Activex controls on MSDN - no luck.
Does anyone know how to control the formatting of caption text when an Activex control have been diabled using VBA?
Thanks For Your Help,