Code for locking windows

[Dean Knox]

Hi,

Does anyone know the vb for disabling window resizing when
the excel window is in the screen but not maximised?

I have tried:

Application.Activewindow.Enableresize = False

But this doesn't lock the window?

Thanks

Dean

 

[Tom Ogilvy]

That command worked fine for me.

xl2000, windows 2000 Professional

 

[Dean Knox]

It only locked the active window not the application
resize window that I need, any ideas?

 

[Tom Ogilvy]

I think you would have to use the windows API to do it - perhaps subclass
excel - I don't have any sample code for you, but you might look at

http://support.microsoft.com/support/?id=185733
HOWTO: Limit a Windows's Minimum and Maximum Size

I know that windows can be set to be resizeable or not - but I doubt you can
change the type of window Excel is (since excel probably manages that), so
you might have to use the subclassing approach in the above article.