Maximizing a workbook

[Guest]

Hi, everybody

Is there a code that maximizes a workbook when it opens?

I tried this:
Sub Workbook_open()
Application.WindowState = xlMaximized
End Sub

But it only maximizes the Excel window.

Any help?

Thanks,
Cabaco

 

[Rob Bovey]

Is there a code that maximizes a workbook when it opens?

I tried this:
Sub Workbook_open()
Application.WindowState = xlMaximized
End Sub

Hi Cabaco,

Here's one way to do it:

ThisWorkbook.Windows(1).WindowState = xlMaximized

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

 

[STEVE BELL]

You are close - try this...

ActiveWindow.WindowState = xlMaximized