VBA code to open a specific worksheet

  • Thread starter Thread starter MohK
  • Start date Start date
M

MohK

Does anyone know the code to open a specific worksheet within a workbook
when you first open the workbook?

I have a main input page within the workbook and would like this to be
the worksheet that opens or is viewable when i first open the workbook
regardless of where i save my work.

Many thanks
Mark
 
Mark,

In a regular module:

Sub Auto_Open()
Worksheets("yoursheetname").Activate
End Sub

or you can user the Workbook_Open Event

John
 
Back
Top