April 2006
Beginner
1114 pages
98h 16m
English
window.EnableResize [= setting]
True allows the user to resize the window; False prohibits resizing. Default is True. Accessing this property causes an error if WindowState is not xlNormal. The following code prevents the user from changing the active window’s size:
Sub TestDisableResize( )
If ActiveWindow.WindowState = xlNormal Then _
ActiveWindow.EnableResize = False
End SubRead now
Unlock full access