Open WB to default sheet

Originally Posted by ftjjk

Is there a way to setup a workbook to automatically open up to a specific sheet each time, regardless of the sheet that was open last time the WB was closed and saved.

If this is a vba solution I am more than willing to attempt it. TIA.

Hi ftjjk,

Try this.
Put into the WorkBook Module.
Change the sheet number to the one which you want to open to.

Private Sub Workbook_Open()
Worksheets("Sheet2").Select
End Sub