LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Opening a workbook window maximized

I am trying to ensure that the sheet window in an Excel workbook always opens
maximized and remains protected in that state, so that users cannot resize
it. If the window element of the workbook is protected and saved before
closing the workbook, it always reopens as a restored window, not maximised,
regardless of the window size when it was closed.

That is the case whether the sizing and protection is done manually, or
using a code fragment such as:-
With Workbooks(WBName)
.Unprotect
.Windows(1).WindowState = xlMaximized
.Protect , True, True
.Close True
End with

This behaviour appears to conflict with the Excel Help (e.g.XLXP) for
"Workbook protection (Windows)", which says:-
"Windows element, When selected, prevents users from:
"Changing the size and position of the windows for the workbook when the
workbook is opened."
"Moving, resizing, or closing the windows. However, they can hide and
unhide windows." "

This behaviour seems to have existed since XL97 through XL2003, and there is
no MS KB article which addresses this issue.

Can anyone help, please?
 
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
Opening excel in a new window sebire Excel Discussion (Misc queries) 4 January 5th 07 04:32 PM
Multiple Spreadsheets Opening in Same Window jordancij Excel Discussion (Misc queries) 2 September 20th 05 04:44 PM
Workbooks Opening Maximized mdalby Excel Discussion (Misc queries) 2 July 26th 05 05:58 PM
Excel window not maximized on start Hennie Excel Discussion (Misc queries) 1 July 25th 05 05:16 PM
How do I get excel to always open with a maximized window Stacymm Excel Discussion (Misc queries) 1 February 10th 05 10:07 PM


All times are GMT +1. The time now is 02:51 AM.

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

About Us

"It's about Microsoft Excel"