ActiveX

To set the background and text colors for headers

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Specify the background color with the ShadowColor property if the AppearanceStyle is classic.
3. Specify the text color with the ShadowText property.
4. If the AppearanceStyle property is set to enhanced, then set the SetEnhancedColumnHeaderColors or the SetEnhancedRowHeaderColors method.