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

  • Thread starter Thread starter Marvin Hlavac
  • Start date Start date
M

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)
 
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
 
Hi Peo,

As far as I know a worksheet is maximized when you open the workbook
Click to expand...

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
Click to expand...



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


Thanks Peo,
 
Back
Top