Maximizing a workbook

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

"Cabaco" <[email protected]> wrote in message
news:[email protected]...
> 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

You are close - try this...

ActiveWindow.WindowState = xlMaximized

--
steveB

Remove "AYN" from email to respond
"Cabaco" <[email protected]> wrote in message
news:[email protected]...
> 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