Open the Workbook sheet (code view) and enter:Private Sub Workbook_Open()UserForm1.Show 'Where UserForm1 is the name of your userformSheet1.Activate 'Where Sheet1 is the sheet you wish the userform toappear on.