ActiveX

To customize grid lines

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. If you want to hide the horizontal grid lines, set the GridShowHoriz property to False.
3. If you want to hide the vertical grid lines, set the GridShowVert property to False.
4. If you want to display the grid lines as dotted, set the GridSolid property to False.
5. If you want to display the grid lines over the background color, set the BackColorStyle property to 1 (Under Grid), 2 (Over Horizontal Grid Only), or 3 (Over Vertical Grid Only).
6. Set the GridColor property.