EnableResize Property

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