Hello.

I have a sheet that have links to other sources. Theres a popup window when I open the workbook that they need to update the workbook to have the information updated.

People in general at my work all seem to press dont update for some reason.
I would like to have a popup that tells the user in our native language that they need to press the update button.

How can I force excel to show my popupwindow BEFORE the update external links popup is shown.

Today I use this code:
Private Sub WORKBOOK_OPEN()
Ans = MsgBox("Message.", vbOK)

End Sub

I only need one button. Today I have OK and Cancel.


/Anders