The right syntax:

Sheets("names").Select

or

Thisworkbook.Sheets("names").Select

Regards,
Stefi

€žTia€� ezt Ã*rta:

Hi
I have a workbook called timesheet i want the first sheet to
automaticly open whenever i open my workbook
the 1st sheet is called names
these are the steps that im using but its not working
Visual basic editor___ view__ code__past code wich is ( Private Sub
Workbook_Open()
timesheet.Sheets("names").Select
End Sub)____ alt+q___ i press on another sheet___ save___ close___

Whenever i reopen it the first sheet does not shows always the last
sheet opened is displayed

Please help