ActiveX
To customize the three-dimensional appearance of button cells
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 as appropriate.
For more information about setting the Col and Row properties, see Using Column and Row Properties.
- If you are selecting a block of cells, set the BlockMode property to True.
- Set the CellType property to 7 (Button).
- If you want to specify the border color, set the TypeButtonBorderColor property.
- If you want to specify the shadow color, set the TypeButtonDarkColor property.
- If you want to specify the highlight color, set the TypeButtonLightColor property.
- If you want to change the width of the highlight and shadow area, set the TypeButtonShadowSize property.