Displaying a user form automatically in excel

Is it possible when I open my applicatin in excel using vba I can get it to automatically display a user form? i.e. initially display a splash screen which will then display a main menu for the system.  In the visual basic editor window if I wish to run the user forms I have to press play and even when i do that it asks me what macros id like to run, however all my macros are invoked within subs.

Thanks,
Natalie