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,