EnableResize Property

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   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