Do you want to make sure a sheet always shows first when a workbook opens? For instance when you open a workbook sheet3 is always the active sheet. Here’s how.

You can refer to a sheet from VBA by it’s program name (ie Sheet3) or by it’s tab name(ie JanData). It is best to use the program name, becuase if the tab name changes, your VBA code that refers to a tab name will no longer work. However if you use the program name a user can change the tab name multiple times and your macro still works.

To make sure a certain sheet is always activated when a workbook opens, just place sheet.activate code in the workbook_open sub. This is an example that activates sheet3 by using the program name everytime a workbook opens.

Private Sub Workbook_Open()
Sheet3.Activate
End Sub
 

And this does it by using the tab name:

Private Sub Workbook_Open()
Sheets("mytabname").Activate
End Sub
 

Sidenote: You must save and restart excel for this to work.

Sidenote: This only works if macros are enabled.

Sidenote: Put this code in the code window for the ThisWorkbook object in the VBE.