open Excel form at startup 1

[proteome]

How do you automatically open a excel form at startup, ie when you click on an excel file the workbook opens a userform.


Thanks

 

[jebenson]

Put the call to show the form in the WorkbookOpen() sub, in the ThisWorkbook module:

Public Sub Workbook_Open()
UserForm1.Show
End Sub

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

 

[proteome]

Thanks a lot