Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i change the default size of a window when it opens mavio Excel Discussion (Misc queries) 0 October 19th 09 03:24 AM
Disabling OneNote Print Window on Excel Cris Excel Discussion (Misc queries) 0 August 11th 09 09:36 AM
how to save a desired window size but hv window comeup fullsz by d smjm1982 Excel Discussion (Misc queries) 1 February 15th 08 11:10 AM
Cannot (re) size Excel Window Terry Excel Discussion (Misc queries) 0 January 25th 06 10:43 AM
Cannot (re) size Excel Window Terry Setting up and Configuration of Excel 0 January 25th 06 10:43 AM


All times are GMT +1. The time now is 08:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"