Oh, yeah I just remembered the reason that line fails - the window is
maximized! You have to use the WindowState property and set it to xlNormal
before you can set EnableResize.

--
Jim
"Jim Rech" wrote in message
...
| You want End Sub not Exit Sub.
|
| The code should work as long as there is an active window. For instance,
if
| it's hidden for any reason it will fail.
|
| --
| Jim
| "BIta" wrote in message
| ups.com...
|| Hello,
||
|| I opened a new insatnce of Excel and then I put the followinf code
|| in the auto_open function
||
|| Sub auto_open
|| ActiveWindow.EnableResize = False
|| Exit Sub
||
|| And then I saved the file and closed it. When I tried to open
|| it I got a run-time error message:
||
|| Application-defined or object-defined error
||
|| Did I make something wrong. I don't want the user to be able to
|| resize the active window in Excel. What should I do?
||
|| Thanks,
|| --Bita
||
|
|