I need a formula for when a workbook is opened it will default to a specific tab.
G Gia Apr 24, 2009 #1 I need a formula for when a workbook is opened it will default to a specific tab.
H Harlan Grove Apr 24, 2009 #2 Gia said: I need a formula for when a workbook is opened it will default to a specific tab. Click to expand... 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
Gia said: I need a formula for when a workbook is opened it will default to a specific tab. Click to expand... 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
S Sheeloo Apr 24, 2009 #3 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
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
