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" wrote:

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