Hi Russ,

Private Sub Workbook_Open()
UserForm1.Show
End Sub

My guess is the when opened via hyperlink, that there is some
confusion as to where userform1 is. But that is my guess.

Suggestions?

Avoid the showing of the form like this:

Private Sub Workbook_Open()
If not Me.IsInPlace Then
UserForm1.Show
End If
End Sub


Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com