ActiveX
To customize the three-dimensional appearance of the headers
At run time,
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
- Set the Col, Col2, Row, and Row2 properties to designate the header cells to change.
- If you are selecting a block of cells, set the BlockMode property to True.
-
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.
- If you selected a block of cells, set the BlockMode property back to False.