ActiveX

To customize the three-dimensional appearance of the headers

At run time,

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Set the Col, Col2, Row, and Row2 properties to designate the header cells to change.
3. If you are selecting a block of cells, set the BlockMode property to True.
4. Provide a three-dimensional appearance by doing one of the following:
   • If you want the header cell to display a flat appearance, set the TypeTextShadow property to False.
   • If you want the cell to display a lowered three-dimensional appearance, set the TypeTextShadow property to False and set the TypeTextShadowIn property to True.

     Note: If you set both the TypeTextShadow and TypeTextShadowIn properties to True, the cell displays a raised shadow effect as specified by the TypeTextShadow property.

5. If you selected a block of cells, set the BlockMode property back to False.