View Single Post
 
Old 09-08-2013, 05:11 AM
MikeyChris MikeyChris is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Aug 2013
Posts: 15
MikeyChris is on a distinguished road
Default PW protected XLSX won't open maximized

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.
Reply With Quote