ActiveX

To prevent resizing of columns and rows

1. If you want to prevent resizing of columns and rows, set the UserResize property to 0. This setting is applied to all sheets in the book.
2. If you want to prevent resizing of columns only, set the UserResize property to 2 (Rows). This setting is applied to all sheets in the book.
3. If you want to prevent resizing of rows only, set the UserResize property to 1 (Cols). This setting is applied to all sheets in the book.
4. If you want to prevent resizing of an individual column, 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. Specify the column with the Col property.
   3. Set the UserResizeCol property to 2 (Off).
5. If you want to prevent resizing of an individual 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. Specify the row with the Row property.
   3. Set the UserResizeRow property to 2 (Off).