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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Mark,

In a regular module:

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

or you can user the Workbook_Open Event

John

MohK wrote:

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

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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

http://www.google.com/groups?hl=en&l...d12011d&rnum=1

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

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