View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
STEVE BELL STEVE BELL is offline
external usenet poster
 
Posts: 692
Default Maximizing a workbook

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