View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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