ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   About disabling Excel window size-change ... (https://www.excelbanter.com/excel-programming/272300-about-disabling-excel-window-size-change.html)

PS[_2_]

About disabling Excel window size-change ...
 
Hi,

When Excel main window is maximazed,
by Double-clicking Application's Menubar(the upper blue part), the window
size is changed.
If possible, I want to disable the window-size change.
Is it possible?

Maybe this question is about win32api.
But I don't know where the win32api-newsgroup is.

Thanks in advance.




Jim Rech

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




All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com