Open userform when worksheet opens advice

[ipbr21054]

Afternoon,

I would like the userform to open when i open the workbook.
At present i have the following which works fine when i navigate worksheet to worksheet but need some advice please for it to run when i open the workbook.

Private Sub Worksheet_Activate()
If Range("A2") = "" Then
Range("I26").Select
SUMMARYSHEETYEAR.Show
Else
End If
End Sub

 

[DanteAmor]

Put following in thisworkbook event:

Private Sub Workbook_Open()
  SUMMARYSHEETYEAR.Show
End Sub

 

[ipbr21054]

Thank You

 

[DanteAmor]

Youre welcome