Show userform at spreadsheet open

[Roger on Excel]

How do you make a userform open when you open a spreadsheet?

Can anyone help?

Thankyou,

Roger [excel2003]

 

[FSt1]

hi
sheet or file?

sheet.....
Private Sub Worksheet_Activate()
Load userform1
userform1.Show 0
End Sub

lookup modal and modaless forms in vb help.

file....
Private Sub Workbook_Open()
Load userform1
userform1.Show 0
End Sub

also see this site....
http://www.mvps.org/dmcritchie/excel/getstarted.htm

regards
FSt1

 

[tpeter]

You could also right click on the tab you want the userform to open on and
type the NameOfYourForm.show. Put this on an on activate event.