Right-click on the Excel Icon left of "File" on the worksheet menu bar.

Select "View Code" to open Thisworkbook module.

Paste the code into that module.

Alt + q to return to the Excel window.

Select any sheet but "Main".

Save, close and re-open.


Gord Dibben MS Excel MVP


On Tue, 1 Jul 2008 04:18:38 -0700 (PDT), Tia wrote:

On Jul 1, 1:21*pm, Dennis wrote:
Click on Tools - Macro - Visual Basic Editor
In the Left Hand Project Pane, Double Click ThisWorkbook
In the Workbook Open Event, put the code below & then Exit and Save the
Workbook.
Open it again and the first sheet should be displayed.

Private Sub Workbook_Open()
* * Me.Sheets(1).Select
End Sub



"Tia" wrote:
Hello
is there is any way so that whenever i open my workbook i see the
first sheet wich is the main sheet with all the employees name on it
they click on their names and it will be linked to their sheet
but what ever y open it the last sheet opened will be displayed not
the main
Is there is any way it shows the main everytime you open ?

Tia- Hide quoted text -

- Show quoted text -

Ok i went to developer visual basic i double clicked on the view excel
file and than view code and and i copy and paste it

Im doing something wrong b its not working
can you help me please im not good in visual basic

Tia