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

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
>

On Jul 1, 1:21*pm, Dennis <Den...@discussions.microsoft.com> 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

I cannot see what you have done wrong so I don't know what to suggest.
What do you mean by double clicked on the "View Excel File" ?
You need to double click on the 'ThisWorkbook' usually at the bottom of a
list of worksheet names on the left hand side of the screen. You should then
paste the code on the right hand pane.

"Tia" wrote:

> On Jul 1, 1:21 pm, Dennis <Den...@discussions.microsoft.com> 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
>

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 <(E-Mail Removed)> wrote:

>On Jul 1, 1:21*pm, Dennis <Den...@discussions.microsoft.com> 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