Put this into the worksheet module for Sheet4
(substitute the name of the form if needed)

Private Sub Worksheet_Activate()
Userform1.Show
End Sub

--
steveB

Remove "AYN" from email to respond
"Steve Klenner" wrote in message
...
I would like to show userform1 automatically when I access sheet4 in my
workbook...anyway to accomplish this?

Steve