View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Smallman Steve Smallman is offline
external usenet poster
 
Posts: 47
Default How maximize open excel workbook

try application.windowstate to maximize the Excel window, then use
activewindow.maximize to maximize the workbook.

Steve
"Flukmu" wrote in message
...

Hi,

We have set some excel workbook as an objet in a Excel workbook. When I
try to open the objet workbook, they both windows (main and the new open
wookbook) appear minimize. We have try :

sub Workbook_Open()
Activeworkbook.windows(1).windowstate = xlmaximized
en sub

Result nothing...

Some tips please would be appreciate,

friendly,

Lecm


--
Flukmu
------------------------------------------------------------------------
Flukmu's Profile:
http://www.excelforum.com/member.php...o&userid=14706
View this thread: http://www.excelforum.com/showthread...hreadid=263312