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