Opening Excel Spreadsheet on a tab

[david.willis]

When I say tab, I of course mean a sheet

 

[JE McGimpsey]

One way:

Put this in your ThisWorkbook code module:

Private Sub Workbook_Open()
Sheets(1).Select
End Sub

If you're not familiar with macro, see

http://www.mvps.org/dmcritchie/excel/getstarted.htm