Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i change the default size of a window when it opens | Excel Discussion (Misc queries) | |||
Disabling OneNote Print Window on Excel | Excel Discussion (Misc queries) | |||
how to save a desired window size but hv window comeup fullsz by d | Excel Discussion (Misc queries) | |||
Cannot (re) size Excel Window | Excel Discussion (Misc queries) | |||
Cannot (re) size Excel Window | Setting up and Configuration of Excel |