ActiveX

To hide a column or row

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. If you want to hide a column,
   1. Specify the column to hide with the Col property.
   2. Set the ColHidden property to True.
3. If you want to hide a row,
   1. Specify the row to hide with the Row property.
   2. Set the RowHidden property to True.