Open Workbook Formula
 

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

Open Workbook Formula
 

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

Formulas can't do this. Only macros can. Can you use macros? If so, in
the ThisWorkbook class module create a Workbook_Open event handler
macro like

Private Sub Workbook_Open()
Me.Worksheets("worksheet name here").Activate
End Sub

Open Workbook Formula
 

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.