Startup Tab

[Larry S]

Is there a way to specify which tab is active when a workbook opens? I'd like
to have one of our custom tabs be the active tab.

Thanks, Larry

 

[Mike H]

Hi,

Alt + f11 to open VB editor. Ctrl+R to open project explorer, double click
'This Workbook' and paste this in on the right. Change the sheet name to suit

Private Sub Workbook_Open()
Sheets("Sheet3").Select
End Sub

Mike

 

[Larry S]

I was talking about the tabs on the ribbon, not sheet tabs.