ActiveX

To set the width of a column

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. At run time, specify the width with the ColWidth property.
   Specify the column number in the lCol parameter of this property. Use the following index values to designate the column width for the following parts of the control:

   To set the column height for . . .	Use the lCol value . . .
   Row header	0
   All columns	–1
   Column specified by the Col property	–2