How maximize open excel workbook
 

Hi,

We have set some excel workbook as an objet in a Excel workbook. When
try to open the objet workbook, they both windows (main and the new ope
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,

Lec

--
Flukm
-----------------------------------------------------------------------
Flukmu's Profile: http://www.excelforum.com/member.php...fo&userid=1470
View this thread: http://www.excelforum.com/showthread.php?threadid=26331

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