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