Put this in your ThisWorkbook code module:

Private Sub Workbook_Open()
Application.GoTo Sheets("Certain_Tab").Range("A1")
End Sub


In article ,
Pietro wrote:

Hi ,
I have an Excel sheet with many tabs..
What should i do to oblige MS Excel to open a certain tab whenever i open
this MS excel sheet ?

Thanx for your help