Here's a little something that's been locking up my machine.

I have a spreadsheet that, when launched, automatically shows a
userform. I use the Workbook_Open event to show the userform. As a
standalone, this spreadsheet works fine. Now, when I hyperlink to
this spreadsheet inside a Word document and then click this hyperlink,
Word goes into "la-la" land (i.e., perpetual hourglass).

This is my Workbook_Open

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?