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?

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


"jbankert" <(E-Mail Removed)> wrote in message
news:1D5080E2-6DF2-4789-9E5E-(E-Mail Removed)...
> 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?