VBA code to open a specific worksheet

[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

 

[John Wilson]

Mark,

In a regular module:

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

or you can user the Workbook_Open Event

John

 

[pfsardella]

Here's a post from earlier this week that provides a few answers.

http://www.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&th=51f10b517d12011d&rnum=1

HTH
Paul