Select First(far left) sheet everytime 1

[robcarr]

Dear All,

Does anybody know how to automatically select the 1st(far left) sheet everytime i open a file using VBA, the first sheet is not named sheet1, but has a different name each month, but I always need to start my coding from this sheet, I have always got no more than 5 sheets in the file, how can this been done.

Thanks in advance,

 

[DaleWatson123321]

This should be all you need. It should be placed in "ThisWorkbook".


Private Sub Workbook_Open()
Worksheets(1).Select
End Sub


Hope this helps.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca