Code for locking windows

  • Thread starter Thread starter Dean Knox
  • Start date Start date
D

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
 
It only locked the active window not the application
resize window that I need, any ideas?
 
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.
 
Back
Top