ActiveX

To freeze columns and rows

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Specify the number of columns to freeze with the ColsFrozen property.
3. Specify the number of rows to freeze with the RowsFrozen property.