Quote:
Originally Posted by MikeyChris
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.