Spread 8.0 Documentation
|
|
ActiveX
|
Support Options
|
ActiveX
To prevent resizing of columns and rows
- 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.
- 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.
- 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.
-
If you want to prevent resizing of an individual column, at run time,
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
- Specify the column with the Col property.
- Set the UserResizeCol property to 2 (Off).
-
If you want to prevent resizing of an individual row, at run time,
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
- Specify the row with the Row property.
- Set the UserResizeRow property to 2 (Off).