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