Default a specific worksheet to be in forefront when open excel?

J

jbankert

Have multiple worksheets in an excel file and want a specific worksheet to be
in the forefront when opening the excel file. How to do this?
 
B

Bernie Deitrick

j,

Put this code into the codemodule of the ThisWorkbook Object.

Private Sub Workbook_Open()
Worksheets(1).Activate
End Sub

Change the 1 to the specific sheet index.

Or, if the users can change the order of the sheets or add new sheet, and you want a specific sheet
selected:

Private Sub Workbook_Open()
Worksheets("Sheet Name").Activate
End Sub

Or, if users might change the name on the tab of that specific sheet:

Private Sub Workbook_Open()
shtCodeName.Activate
End Sub

If you are unclear on the how to implement any of these, post back.

HTH,
Bernie Deitrick
MS Excel MVP
 
Top