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