Window.EnableResize Property (Excel)
True if the window can be resized. Read/write Boolean.
Syntax
expression .EnableResize
expression A variable that represents a Window object.
Example
This example sets the active window so that it cannot be resized.
ActiveWindow.EnableResize = False