calling VBA user form as soon as excell file is opened 1

[unforgiven]

Hello I'm usally a VB programmer, but i've been asked to create a VBA interface for a existing spreadsheet. I've got interface stuff down. My question is how do I call or make my vba userform open automaticaly as soon the file is opened. The VBA userform should be open and the excell sheet should be in the background. Any help would be greatly appreciated.

 

[jyw]

Open the Visual Basic Editor (Alt+F11) and write this :

Private Sub Workbook_Open()
UserForm1.Show
End Sub

where UserForm1 is the name of your form. That's it.

 

[unforgiven]

Thanks so much for the help!