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" wrote in message
...
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" wrote in message
...
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