Write the below code in your ThisWorkbook.

Double Click ThisWorkbook from your VB Editor and Choose Workbook from the
first drop down list in your right hand side.

The you will get WorkBook_Open event.

In that write the below code.

UserForm1.Show

Then Save your workbook, Close and reopen it again. Then your form  will peep
out in front of you.