View Single Post
 
Old 09-08-2013, 08:44 PM
excelledsoftware excelledsoftware is offline Windows 7 64bit Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Quote:
Originally Posted by MikeyChris View Post
Hello,
I have several password protected workbooks and I can't get any of them to open maximized. Regardless of what size the window is when I close the wb, when I open it again it is full width, half height centered. I have set the shortcut to the workbook to run maximized, but it doesn't care. Un-pw protected wb's behave (i.e. open as they were when last closed).
Any idea why a pw protect wb won't obey the rules? Is there a vba script I can insert somewhere to make all wb's open maximized? I thought I had already done this in my personal workbook (is that the right name?) but can't find it anywhere. As you can see, I'm not up to speed on all this, so any detailed help is appreciated.
When you protected it. What options did you enable? window structure is one of them which may be the reason.
Reply With Quote