How maximize open excel workbook

F

Flukmu

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
 
S

Steve Smallman

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

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maximize Excel 1
Copying cells and formula from closed workbook to all sheets in open workbook 0
How to de-activate Menu bar in only one Excel Workbook ????????/ 1
Why is my Workbook Open procedure not working 1
Open Excel workbook from Access 4
Auto Open question 2
adding code to a workbook programmably 1
Access Data from Workbook without seeing the workbook open. 1

Top