opening on same sheet

[Tony]

When I open my excel program if i have been I want it to
always open in the same worksheet i am using
Private Sub Workbook_Open()
Worksheets("names").Show
End Sub
it is telleing me i have the wrong code. What am i
missing?

 

[Frank Kabel]

Hi
try
Private Sub Workbook_Open()
Worksheets("names").activate
End Sub