Talk about running around in a circle... From what I understand you ar requiring a Userform to become visible upon opening of a particular workbook.
Private Sub Workbook_Open()
Userform1.Show     <- change to correct name of Userform
End Sub