Sub Auto_Open()
Worksheets("sheet1").Activate
End sub

placed in a general module. Or to use the Workbook_Open Event, go to the
project explorer and double click on the ThisWorkbook entry for your project

In the left dropdown at the top, select Workbook, in the Right, Open

Private Sub Workbook_Open()
Worksheets("sheet1").Activate
End Sub

--
Regards,
Tom Ogilvy

Stu wrote in message
...
How do I set a macro to open a specific sheet each time the XL file is
opened?

Thanks
--
Stu