You can use the Workbook_Open event to specify which worksheet is active upon
opening.

Private Sub Workbook_Open()
Worksheets("Sheet3").Activate
End Sub

The above code snippet would go in the ThisWorkbook code module. To access
that code module, press Alt + F11. Either double click on ThisWorkbook in
the project window in the left panel of the screen, or right click on it and
then click on View Code from the drop down menu. If you put the above code
in that code module, it will bring up sheet 3 each time you open the workbook.

"Tim_at_TDR" wrote:

Looking for a way to output to multiple sheets when creating an excel file
from a program. Is there some command-line switch or other feature one can
use to specifiy which worksheet to open or write to when an excel file is
openned?