About disabling Excel window size-change ...
If the workbook window is maximized it will enlarge when Excel is maximized
(I think that's what you're saying).
So you have to "restore" the workbook window, and protect it:
ActiveWindow.WindowState = xlNormal
ActiveWorkbook.Protect Windows:=True
--
Jim Rech
Excel MVP
|