see Chip Pearson's page on events

http://www.cpearson.com/excel/events.htm

You would use the Workbook_Open event which would be placed in the
thisworkbook module.

by the way, this is showing the userform.

Private Sub workbook_Open()
userform1.show
End Sub

--
Regards,
Tom Ogilvy


"Szadkowski" wrote in message
...
I have a userform and i was wondering how to initialize it so it pops up
when
the user loads the workbook..