With a file named Book1.xls (using Excel 2003 on a Vista 32 bit system) that has the code ( Application.WindowState = xlMinimized) in Workbook_Open :
a. Double click on Book1.xls. Excel file is opened and runs minimized.
b. Double click on RunBook1.bat. Excel file is opened and runs minimized.
c. Double click on RunBook2And1.bat. Excel file(s) are opened and both are minimized. Book2.xls is an ordinary Excel file with NO Workbook_Open() code.
c. Double click on RunBook1And2.bat. Book1 is minimized. Book2 is visible. Book2.xls is an ordinary Excel file with NO Workbook_Open() code.
Lewis
Bookmarks