Open to tab

P

Pietro

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
 
J

JE McGimpsey

Put this in your ThisWorkbook code module:

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