VBA for Excel 97 – Macro for Linking

I have created several order forms that my company uses for our salesreps. They all link to an account database for autofill.
Everytime a rep opens the form, the dialog box “To Update all links, click yes, To keep existing info, click no”, appears. How can I write a macro that runs when the form opens, and automatically says no, without user seeing?