Starting MS Excel with a worksheet other than SHEET 1

[IGNACIO]

I have renamed several worksheets in my MS Excel workbook. I want Excel to
start with a particular sheet, but it always start with the same one
(supposed to be SHEET 1). How can I start MS Excel with a designated
worksheet?

Thanks,

ICG

 

[Otto Moehrbach]

Do you mean that you want a specific file to always open on a specific
sheet? By default, the file will always open on the sheet that was the
active sheet when the file was last saved. But you can write a small macro
in the workbook module to force a specific sheet to be the active sheet on
opening. Something like this:
Private Sub Workbook_Open()
Sheets("MySheet").Activate
End Sub
With the file open on the screen, right-click on the Excel icon to the left
of the menu item "File" of the menu across the top of the screen. Select
View Code. Paste the above macro into the module displayed. Change
"MySheet" to the name of the worksheet you want. HTH Otto

 

[Don Guillett]

in the ThisWorkbook module, workbook_open event use sheets("sheet1").select