How to disable Max / Min WindowState

[Emily]

We can use Application.WindowState = xlMaximized to make the window maximise. How about disable the max and min command?

 

[stevebausch]

I assume you mean the little buttons at the top right of the Excel Window.

Just found this:
ActiveWindow.EnableResize = False

And there are WindowResize events for Application and Window.
This message was edited by stevebausch on 2002-09-22 20:22

 

[Emily]

Error is detected. Can you show me an example?

Thanks