![]() |
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. |
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