View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BIta BIta is offline
external usenet poster
 
Posts: 4
Default Setting EnableResize = False

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