In your Project window click on ThisWorkbook, Choose Workbook in the left dropdown box of the code window, and Choose Open in the right dropdown box of the code window

Put in this code, where "Sheet1" is the name of the sheet you want as your welcome shee

Private Sub Workbook_Open() '<<this is provide
Sheets("Sheet1").Activat
End Sub '<<this is provide

----- Stefano wrote: ----

hi

i've got a workbook with many sheets. how do i set it so that sheet1 will show when a user loads the workbook

thanks