Open the Workbook sheet (code view) and enter:

Private Sub Workbook_Open()
UserForm1.Show 'Where UserForm1 is the name of your userform
Sheet1.Activate 'Where Sheet1 is the sheet you wish the userform to
appear on.

Thanks

It is working..............

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.