Quick workspace question...
Posted by Kristy on October 26, 2001 7:44 AM
I was just wondering if there is any way to make sure that the worksheets open as maximized.
They were that way when I saved the workspace, but whenever I open it they are not until I maximize one of them.
Not a big deal, just aggravating.
Thanks!
Posted by Tom Urtis on October 26, 2001 11:40 PM
Kristy,
You can solve this by putting the following line of code in your Auto_Open subroutine (or Workbook_Open event procedure, whichever one of those two open routines you are using):
ActiveWindow.WindowState = xlMaximized
Tom Urtis
Posted by Kristy on October 29, 2001 6:21 AM
Umm...not using an "open routine..."
...I don't even know what one is. All I did was open all of the workbooks I needed, then went to File/Save Workspace.
