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