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

That command worked fine for me.

xl2000, windows 2000 Professional
--
Regards,
Tom Ogilvy

"Dean Knox" wrote in message
...
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?




-----Original Message-----
That command worked fine for me.

xl2000, windows 2000 Professional
--
Regards,
Tom Ogilvy

"Dean Knox" wrote in message
...
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


.

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.

--
Regards,
Tom Ogilvy

"Dean Knox" wrote in message
...
It only locked the active window not the application
resize window that I need, any ideas?




-----Original Message-----
That command worked fine for me.

xl2000, windows 2000 Professional
--
Regards,
Tom Ogilvy

"Dean Knox" wrote in message
...
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


.