I'd like my worksheet (and workbook if possible, too) always maximized when opened.

[Marvin Hlavac]

Hi Excel gurus.

On several occasions in the past month you helped me greatly and a big
THANKS is due.
Two questions today:

1. Is there a way to force a worksheet to open maximized?

2. Is there a way to force a workbook to open maximized? (This one I could
do with settings of a desktop shortcut if there is no other way to do it
within Excel)

 

[Peo Sjoblom]

1.

As far as I know a worksheet is maximized when you open the workbook


2.

Private Sub Workbook_Open()
ActiveWindow.WindowState = xlMaximized
End Sub


press Alt + F11, find the workbook you want this and double click
ThisWorkbook and paste in the above

 

[Marvin Hlavac]

Hi Peo,

As far as I know a worksheet is maximized when you open the workbook

It is maximized most of the time, but on two occasions during the last few
days for some reason a worksheet I've been working on didn't open maximized
in my workbook. I don't know why...

Private Sub Workbook_Open()
ActiveWindow.WindowState = xlMaximized
End Sub


press Alt + F11, find the workbook you want this and double click
ThisWorkbook and paste in the above

For some reason it doesn't work, but I will play with it a little bit
longer...


Thanks Peo,