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
|