Windows Forum

Ask something
Discussion Locked

VBA for Excel 97 - Macro for Linking

0 helpful
7 replies

by rvs

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

7 replies

by rvs

I have tried that approach, problem is it affects the way excel handles all documents that use the linking method. The other disadvantage is that it automatically answers yes (when false is used) and the user has to wait for the forms to relink.

by mbarker734

On the sheet you want perform the autoupdate with out option do the following

Tool>Options>Edit
uncheck Ask to update automatic links

Your sheet will no update without asking if you want to or not.

Hope this helped.

Mark

by mbarker734

OK, can't type as fast as I think.

Your sheet will update the links without asking you if you want to or not.

This discussion is closed to new replies.