Press Alt-F11 to open VB Editor
Double click on 'ThisWorkbook' on the left
Paste this macro in the right pane after replacing Sheet2 with the name of
the sheet you want to open to
Private Sub Workbook_Open()

Worksheets("Sheet2").Activate

End Sub


"Gia" wrote:

I need a formula for when a workbook is opened it will default to a specific
tab.