EnableResize Property

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

True if the spreadsheet control can be resized by the user. Set this property to False to prevent the user from resizing the spreadsheet control. The default value is True. Read/write Boolean.

expression.EnableResize

expression   Required. An expression that returns a Window object.

Example

This example sets the height and width of the spreadsheet control and then prevents the user from resizing the control.

  Sub Size_Spreadsheet()
   ' Set the height of the spreadsheet control.
   Spreadsheet1.Height = 4000

   ' Set the width of the spreadsheet control.
   Spreadsheet1.Width = 6000

   ' Prevent the user from resizing the spreadsheet control.
   Spreadsheet1.ActiveWindow.EnableResize = False
End Sub