Put this in your sheet4 code module:

Private Sub Worksheet_Activate()
Dim fmMyForm As UserForm1
Set fmMyForm = New UserForm1
fmMyForm.Show
End Sub


In article ,
"Steve Klenner" wrote:

I would like to show userform1 automatically when I access sheet4 in my
workbook...anyway to accomplish this?